WorksheetProtectionModel

Overview

WorksheetProtectionModel is a class in Aspose.Cells for NET.

WorksheetProtectionModel.Clear resets all protection settings to their defaults.

Properties

Name	Type	Access	Description
`IsProtected`	`bool`	Read/Write	Indicates if the worksheet is currently protected
`Objects`	`bool`	Read/Write	Gets or sets permission to edit objects on the protected sheet
`Scenarios`	`bool`	Read/Write	Indicates whether scenario manager is protected
`FormatCells`	`bool`	Read/Write	Gets or sets permission to format cells on the protected sheet
`FormatColumns`	`bool`	Read/Write	Indicates if column formatting is locked
`FormatRows`	`bool`	Read/Write	Indicates if row formatting is locked
`InsertColumns`	`bool`	Read/Write	Gets or sets permission to insert columns on the protected sheet
`InsertRows`	`bool`	Read/Write	Indicates if inserting rows is prohibited
`InsertHyperlinks`	`bool`	Read/Write	Indicates if inserting hyperlinks is prohibited
`DeleteColumns`	`bool`	Read/Write	Indicates if deleting columns is prohibited
`DeleteRows`	`bool`	Read/Write	Gets or sets permission to delete rows on the protected sheet
`SelectLockedCells`	`bool`	Read/Write	Gets or sets permission to select locked cells
`Sort`	`bool`	Read/Write	Indicates if sorting is allowed on the worksheet
`AutoFilter`	`bool`	Read/Write	Gets or sets permission to use auto‑filter on the protected sheet
`PivotTables`	`bool`	Read/Write	Indicates if pivot tables are protected from editing
`SelectUnlockedCells`	`bool`	Read/Write	Gets or sets permission to select unlocked cells
`PasswordHash`	`string?`	Read/Write	Gets or sets the stored password hash for worksheet protection
`AlgorithmName`	`string?`	Read/Write	Holds the name of the hash algorithm used for protection
`HashValue`	`string?`	Read/Write	Holds the hash value derived from the protection password
`SaltValue`	`string?`	Read/Write	Holds the salt used in the password hashing process
`SpinCount`	`string?`	Read/Write	Gets or sets the number of hash iterations for password protection

Methods

Signature	Description
`Clear()`	Resets all protection settings to their defaults
`HasStoredState()`	Indicates whether protection settings have been saved