Provides information about the types of changes that are disabled when the associated Worksheet is protected.
Constructors
Section titled "Constructors"WorksheetProtection
new WorksheetProtection(a: Worksheet): WorksheetProtectionReturns WorksheetProtection
Properties
Section titled "Properties"$t: TypeallowDeletingColumns
Section titled "allowDeletingColumns"allowDeletingColumns: booleanallowDeletingRows
Section titled "allowDeletingRows"allowDeletingRows: booleanallowEditObjects
Section titled "allowEditObjects"allowEditObjects: booleanallowEditScenarios
Section titled "allowEditScenarios"allowEditScenarios: booleanallowFiltering
Section titled "allowFiltering"allowFiltering: booleanallowFormattingCells
Section titled "allowFormattingCells"allowFormattingCells: booleanallowFormattingColumns
Section titled "allowFormattingColumns"allowFormattingColumns: booleanallowFormattingRows
Section titled "allowFormattingRows"allowFormattingRows: booleanallowInsertingColumns
Section titled "allowInsertingColumns"allowInsertingColumns: booleanallowInsertingHyperlinks
Section titled "allowInsertingHyperlinks"allowInsertingHyperlinks: booleanallowInsertingRows
Section titled "allowInsertingRows"allowInsertingRows: booleanallowSorting
Section titled "allowSorting"allowSorting: booleanallowUsingPivotTables
Section titled "allowUsingPivotTables"allowUsingPivotTables: booleanselectionMode
Section titled "selectionMode"selectionMode: WorksheetProtectedSelectionModeMethods
Section titled "Methods"allowedEditRanges
Section titled "allowedEditRanges"Gets the range at the specified index in the collection. The range at the specified index.
allowedEditRanges(index: number): WorksheetProtectedRangeParameters
- index:
numberThe zero-based index of the range to get.