Enum SpreadsheetProtection

[Flags]
public enum SpreadsheetProtection

Fields

AllowAutoFilter = 4096: Specifies that filtering is allowed for the associated data.
AllowDeleteColumns = 256: Specifies an option that enables the deletion of columns.
AllowDeleteRows = 512: Specifies the option to allow the deletion of rows in the xlsx worksheet.
AllowFormatCells = 4: Specifies that cell formatting is allowed.
AllowFormatColumns = 8: Specifies that column formatting is allowed.
AllowFormatRows = 16: Specifies that row formatting is allowed.
AllowInsertColumns = 32: Specifies that columns can be inserted into the xlsx worksheet.
AllowInsertHyperlinks = 128: Specifies that hyperlinks can be inserted.
AllowInsertRows = 64: Specifies an option that allows rows to be inserted into the xlsx worksheet.
AllowPivotTables = 8192: Specifies that pivot table functionality is enabled in the data model.
AllowSort = 2048: Specifies the option to allow sorting of data in the xlsx worksheet.
Default = -1: Default protection (all default Excel protections)
LockSelectionLockedCells = 1024: Specifies the option that disables the selection of locked cells.
LockSelectionUnlockedCells = 16384: Specifies the option that the selection of unlocked cells should be locked.
None = 0: All spreadsheets are protected against any form of editing.
ObjectsLocked = 1: Objects (e.g. rectangles) are locked.
ScenariosLocked = 2: Scenarios are locked (can't be added, edited, deleted or run).