asposecells.api

Classes

Constants

asposecells.api

Class ProtectedRange

A specified range to be allowed to edit when the sheet protection is ON.

Property Getters/Setters Summary
`method`	`getCellArea()`
	Gets the CellArea object represents the cell area to be protected.
`method`	`isProtectedWithPassword()`
	Indicates whether the worksheets is protected with password.
`method`	`getName()`
`method`	`setName(value)`
	Gets the Range title. This is used as a descriptor, not as a named range definition.
`method`	`getPassword()`
`method`	`setPassword(value)`
	Represents the password to protect the range.
`method`	`getSecurityDescriptor()`
`method`	`setSecurityDescriptor(value)`
	The security descriptor defines user accounts who may edit this range without providing a password to access the range.

Method Summary
`method`	`addArea(startRow, startColumn, endRow, endColumn)`
`method`	Adds a referred area to this
`method`	`getAreas()`
`method`	Gets all referred areas.

- Property Getters/Setters Detail
  - getName/setName : String
```
String getName() / setName(value)
```
    Gets the Range title. This is used as a descriptor, not as a named range definition.
  - getCellArea : CellArea
```
CellArea getCellArea()
```
    Gets the CellArea object represents the cell area to be protected.
  - isProtectedWithPassword : boolean
```
boolean isProtectedWithPassword()
```
    Indicates whether the worksheets is protected with password.
  - getPassword/setPassword : String
```
String getPassword() / setPassword(value)
```
    Represents the password to protect the range.
  - getSecurityDescriptor/setSecurityDescriptor : String
```
String getSecurityDescriptor() / setSecurityDescriptor(value)
```
    The security descriptor defines user accounts who may edit this range without providing a password to access the range.
- Method Detail
  - getAreas
```
CellArea[] getAreas()
```
    Gets all referred areas.
    Returns:
    Returns all referred areas.
  - addArea
```
 addArea(startRow, startColumn, endRow, endColumn)
```
    Adds a referred area to this
    Parameters:
    startRow: int - The start row.
    startColumn: int - The start column.
    endRow: int - The end row.
    endColumn: int - The end column.