WorksheetProtectionModel
Overview
WorksheetProtectionModel is a class in Aspose.Cells FOSS for .NET.
Represents worksheet protection model.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
IsProtected | bool | Read/Write | Gets or sets whether the worksheet is protected |
Objects | bool | Read/Write | Gets or sets whether objects on the sheet can be edited when protected |
Scenarios | bool | Read/Write | Gets or sets whether scenario manager is usable when protected |
FormatCells | bool | Read/Write | Gets or sets whether cell formatting is allowed when protected |
FormatColumns | bool | Read/Write | |
FormatRows | bool | Read/Write | |
InsertColumns | bool | Read/Write | Gets or sets whether columns can be inserted when protected |
InsertRows | bool | Read/Write | |
InsertHyperlinks | bool | Read/Write | Gets or sets whether hyperlinks can be added when protected |
DeleteColumns | bool | Read/Write | |
DeleteRows | bool | Read/Write | Gets or sets whether rows can be deleted when protected |
SelectLockedCells | bool | Read/Write | Gets or sets whether locked cells can be selected when protected |
Sort | bool | Read/Write | Gets or sets whether sorting is allowed when protected |
AutoFilter | bool | Read/Write | Gets or sets whether auto‑filter can be used when protected |
PivotTables | bool | Read/Write | Gets or sets whether pivot tables can be modified when protected |
SelectUnlockedCells | bool | Read/Write | |
PasswordHash | string | Read/Write | Gets or sets the hashed password for worksheet protection |
AlgorithmName | string | Read/Write | Gets or sets the name of the hash algorithm used |
HashValue | string | Read/Write | Gets or sets the base64‑encoded hash of the password |
SaltValue | string | Read/Write | Gets or sets the salt used in the password hash |
SpinCount | string | Read/Write | Gets or sets the number of hash iterations for password protection |
Methods
| Signature | Description |
|---|---|
Clear() | Clears the current state. |
HasStoredState() | if the condition is met; otherwise, . |