Click or drag to resize
WorksheetProtection Class
Protection settings. Supported in XLSX only.
Inheritance Hierarchy
SystemObject
  GemBox.SpreadsheetWorksheetProtection

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1033
Syntax
public sealed class WorksheetProtection

The WorksheetProtection type exposes the following members.

Properties
  NameDescription
Public propertyAllowDeletingColumns
Gets or sets if deleting columns is allowed.
Public propertyAllowDeletingRows
Gets or sets if deleting rows is allowed.
Public propertyAllowEditingObjects
Gets or sets if editing objects is allowed.
Public propertyAllowEditingScenarios
Gets or sets if editing scenarios is allowed.
Public propertyAllowFormattingCells
Gets or sets if formatting cells is allowed.
Public propertyAllowFormattingColumns
Gets or sets if formatting columns is allowed.
Public propertyAllowFormattingRows
Gets or sets if formatting rows is allowed.
Public propertyAllowInsertingColumns
Gets or sets if inserting columns is allowed.
Public propertyAllowInsertingHyperlinks
Gets or sets if inserting hyperlinks is allowed.
Public propertyAllowInsertingRows
Gets or sets if inserting rows is allowed.
Public propertyAllowSelectingLockedCells
Gets or sets if selecting locked cells is allowed. Default value is .
Public propertyAllowSelectingUnlockedCells
Gets or sets if selecting unlocked cells is allowed. Default value is .
Public propertyAllowSorting
Gets or sets if sorting is allowed.
Public propertyAllowUsingAutoFilter
Gets or sets if using autofilter is allowed.
Public propertyAllowUsingPivotTableReports
Gets or sets if using pivot table reports is allowed.
Public propertyPasswordHash
Gets or sets the password hash for protected sheet.
Top
Methods
  NameDescription
Public methodSetPassword
Sets the password for protected sheet.
Top
Remarks
Properties in this class are simply written to Excel file and have no effect on the behavior of this library. For more information on worksheet protection, consult Microsoft Excel documentation.
See Also