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: TypeAccessors
Section titled "Accessors"allowDeletingColumns
Section titled "allowDeletingColumns"Returns a boolean indicating if the deletion of columns is allowed in a protected worksheet.
get allowDeletingColumns(): boolean
Returns boolean
set allowDeletingColumns(a: boolean): voidParameters
- a:
boolean
Returns void
allowDeletingRows
Section titled "allowDeletingRows"Returns a boolean indicating if the deletion of rows is allowed in a protected worksheet.
get allowDeletingRows(): boolean
Returns boolean
set allowDeletingRows(a: boolean): voidParameters
- a:
boolean
Returns void
allowEditObjects
Section titled "allowEditObjects"Returns a boolean indicating if objects such as shapes, comments, charts and controls may be created or changed when the worksheet is protected.
get allowEditObjects(): boolean
Returns boolean
set allowEditObjects(a: boolean): voidParameters
- a:
boolean
Returns void
allowEditScenarios
Section titled "allowEditScenarios"Returns a boolean indicating if existing scenarios are protected when the worksheet is protected.
get allowEditScenarios(): boolean
Returns boolean
set allowEditScenarios(a: boolean): voidParameters
- a:
boolean
Returns void
allowFiltering
Section titled "allowFiltering"Returns a boolean indicating if the user may use an auto filter created before the worksheet was protected.
get allowFiltering(): boolean
Returns boolean
set allowFiltering(a: boolean): voidParameters
- a:
boolean
Returns void
allowFormattingCells
Section titled "allowFormattingCells"Returns a boolean indicating if the user may change the formatting of cells in a protected worksheet.
get allowFormattingCells(): boolean
Returns boolean
set allowFormattingCells(a: boolean): voidParameters
- a:
boolean
Returns void
allowFormattingColumns
Section titled "allowFormattingColumns"Returns a boolean indicating if the user may change column information such as its width or visibility in a protected worksheet.
get allowFormattingColumns(): boolean
Returns boolean
set allowFormattingColumns(a: boolean): voidParameters
- a:
boolean
Returns void
allowFormattingRows
Section titled "allowFormattingRows"Returns a boolean indicating if the user may change row information such as its height or visibility in a protected worksheet.
get allowFormattingRows(): boolean
Returns boolean
set allowFormattingRows(a: boolean): voidParameters
- a:
boolean
Returns void
allowInsertingColumns
Section titled "allowInsertingColumns"Returns a boolean indicating if the user may insert columns in a protected worksheet.
get allowInsertingColumns(): boolean
Returns boolean
set allowInsertingColumns(a: boolean): voidParameters
- a:
boolean
Returns void
allowInsertingHyperlinks
Section titled "allowInsertingHyperlinks"Returns a boolean indicating if the user may insert hyperlinks in unlocked cells in a protected worksheet.
get allowInsertingHyperlinks(): boolean
Returns boolean
set allowInsertingHyperlinks(a: boolean): voidParameters
- a:
boolean
Returns void
allowInsertingRows
Section titled "allowInsertingRows"Returns a boolean indicating if the user may insert rows in a protected worksheet.
get allowInsertingRows(): boolean
Returns boolean
set allowInsertingRows(a: boolean): voidParameters
- a:
boolean
Returns void
allowSorting
Section titled "allowSorting"Returns a boolean indicating if the sorting is allowed in a protected worksheet.
get allowSorting(): boolean
Returns boolean
set allowSorting(a: boolean): voidParameters
- a:
boolean
Returns void
allowUsingPivotTables
Section titled "allowUsingPivotTables"Returns a boolean indicating if the user can change pivot tables in a protected worksheet.
get allowUsingPivotTables(): boolean
Returns boolean
set allowUsingPivotTables(a: boolean): voidParameters
- a:
boolean
Returns void
selectionMode
Section titled "selectionMode"Returns or sets an enumeration used to indicate how cell selection should be affected when the associated Worksheet is protected.
get selectionMode(): WorksheetProtectedSelectionMode
Returns WorksheetProtectedSelectionMode
Methods
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.