WorksheetProtectionModel

Overview

WorksheetProtectionModel is a class in Aspose.Cells FOSS for Java.

Represents the protection model for a worksheet in an Excel file.

Properties

Name	Type	Access	Description
`isProtected`	`boolean`	Read	Returns the protected.
`objects`	`boolean`	Read	Returns the objects.
`scenarios`	`boolean`	Read	Returns the scenarios.
`formatCells`	`boolean`	Read	Returns the format cells.
`formatColumns`	`boolean`	Read	Returns the format columns.
`formatRows`	`boolean`	Read	Returns the format rows.
`insertColumns`	`boolean`	Read	Returns the insert columns.
`insertRows`	`boolean`	Read	Returns the insert rows.
`insertHyperlinks`	`boolean`	Read	Returns the insert hyperlinks.
`deleteColumns`	`boolean`	Read	Returns the delete columns.
`deleteRows`	`boolean`	Read	Returns the delete rows.
`selectLockedCells`	`boolean`	Read	Returns the select locked cells.
`sort`	`boolean`	Read	Returns the sort.
`autoFilter`	`boolean`	Read	Returns the auto filter.
`pivotTables`	`boolean`	Read	Returns the pivot tables.
`selectUnlockedCells`	`boolean`	Read	Returns the select unlocked cells.
`passwordHash`	`String`	Read	Returns the password hash.
`algorithmName`	`String`	Read	Returns the algorithm name.
`hashValue`	`String`	Read	Returns the hash value.
`saltValue`	`String`	Read	Returns the salt value.
`spinCount`	`String`	Read	Returns the spin count.

Methods

Signature	Description
`getIsProtected()` → `boolean`	Returns the protected.
`setIsProtected(isProtected: boolean)`	Sets the protected.
`getObjects()` → `boolean`	Returns the objects.
`setObjects(objects: boolean)`	Sets the objects.
`getScenarios()` → `boolean`	Returns the scenarios.
`setScenarios(scenarios: boolean)`	Sets the scenarios.
`getFormatCells()` → `boolean`	Returns the format cells.
`setFormatCells(formatCells: boolean)`	Sets the format cells.
`getFormatColumns()` → `boolean`	Returns the format columns.
`setFormatColumns(formatColumns: boolean)`	Sets the format columns.
`getFormatRows()` → `boolean`	Returns the format rows.
`setFormatRows(formatRows: boolean)`	Sets the format rows.
`getInsertColumns()` → `boolean`	Returns the insert columns.
`setInsertColumns(insertColumns: boolean)`	Sets the insert columns.
`getInsertRows()` → `boolean`	Returns the insert rows.
`setInsertRows(insertRows: boolean)`	Sets the insert rows.
`getInsertHyperlinks()` → `boolean`	Returns the insert hyperlinks.
`setInsertHyperlinks(insertHyperlinks: boolean)`	Sets the insert hyperlinks.
`getDeleteColumns()` → `boolean`	Returns the delete columns.
`setDeleteColumns(deleteColumns: boolean)`	Sets the delete columns.
`getDeleteRows()` → `boolean`	Returns the delete rows.
`setDeleteRows(deleteRows: boolean)`	Sets the delete rows.
`getSelectLockedCells()` → `boolean`	Returns the select locked cells.
`setSelectLockedCells(selectLockedCells: boolean)`	Sets the select locked cells.
`getSort()` → `boolean`	Returns the sort.
`setSort(sort: boolean)`	Sets the sort.
`getAutoFilter()` → `boolean`	Returns the auto filter.
`setAutoFilter(autoFilter: boolean)`	Sets the auto filter.
`getPivotTables()` → `boolean`	Returns the pivot tables.
`setPivotTables(pivotTables: boolean)`	Sets the pivot tables.
`getSelectUnlockedCells()` → `boolean`	Returns the select unlocked cells.
`setSelectUnlockedCells(selectUnlockedCells: boolean)`	Sets the select unlocked cells.
`getPasswordHash()` → `String`	Returns the password hash.
`setPasswordHash(passwordHash: String)`	Sets the password hash.
`getAlgorithmName()` → `String`	Returns the algorithm name.
`setAlgorithmName(algorithmName: String)`	Sets the algorithm name.
`getHashValue()` → `String`	Returns the hash value.
`setHashValue(hashValue: String)`	Sets the hash value.
`getSaltValue()` → `String`	Returns the salt value.
`setSaltValue(saltValue: String)`	Sets the salt value.
`getSpinCount()` → `String`	Returns the spin count.
`setSpinCount(spinCount: String)`	Sets the spin count.
`clear()`	Clears all protection settings to their default values.
`hasStoredState()` → `boolean`	Determines whether any protection state has been stored.