WorksheetProtection

Overview

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

Represents protection settings for a worksheet.

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.

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.