PicoXLSX Library Documentation
 | WorksheetSheetProtectionValue Enumeration |
Enum to define the possible protection types when protecting a worksheet
Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
SyntaxC#
public enum SheetProtectionValue
Members| Member name | Value | Description | |
|---|---|---|---|
| objects | 0 | If selected, the user can edit objects if the worksheets is protected | |
| scenarios | 1 | If selected, the user can edit scenarios if the worksheets is protected | |
| formatCells | 2 | If selected, the user can format cells if the worksheets is protected | |
| formatColumns | 3 | If selected, the user can format columns if the worksheets is protected | |
| formatRows | 4 | If selected, the user can format rows if the worksheets is protected | |
| insertColumns | 5 | If selected, the user can insert columns if the worksheets is protected | |
| insertRows | 6 | If selected, the user can insert rows if the worksheets is protected | |
| insertHyperlinks | 7 | If selected, the user can insert hyper links if the worksheets is protected | |
| deleteColumns | 8 | If selected, the user can delete columns if the worksheets is protected | |
| deleteRows | 9 | If selected, the user can delete rows if the worksheets is protected | |
| selectLockedCells | 10 | If selected, the user can select locked cells if the worksheets is protected | |
| sort | 11 | If selected, the user can sort cells if the worksheets is protected | |
| autoFilter | 12 | If selected, the user can use auto filters if the worksheets is protected | |
| pivotTables | 13 | If selected, the user can use pivot tables if the worksheets is protected | |
| selectUnlockedCells | 14 | If selected, the user can select unlocked cells if the worksheets is protected |
See Also