aspose.cells

Classes

Constants

Class ProtectedRange

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

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

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

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