ProtectedRange
Source: aspose.
A specified range to be allowed to edit when the sheet protection is ON.
Methods
addArea(startRow, startColumn, endRow, endColumn)
Adds a referred area to this
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
startRow |
Number |
|
The start row. |
|
startColumn |
Number |
|
The start column. |
|
endRow |
Number |
|
The end row. |
|
endColumn |
Number |
|
The end column. |
getAreas() → Array of CellArea
Gets all referred areas.
- Returns
-
Array of CellAreaReturns all referred areas.
getCellArea()
Gets the CellArea object represents the cell area to be protected.
getName()
Gets the Range title. This is used as a descriptor, not as a named range definition.
getPassword()
Represents the password to protect the range.
getSecurityDescriptor()
The security descriptor defines user accounts who may edit this range without providing a password to access the range.
isProtectedWithPassword()
Indicates whether the worksheets is protected with password.
setName()
Gets the Range title. This is used as a descriptor, not as a named range definition.
setPassword()
Represents the password to protect the range.
setSecurityDescriptor()
The security descriptor defines user accounts who may edit this range without providing a password to access the range.