aspose.cells

Class ProtectedRange

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

Property Getters/Setters Summary
functiongetCellArea()
Gets the CellArea object represents the cell area to be protected.
functiongetName()
function
setName(value)
           Gets the Range title. This is used as a descriptor, not as a named range definition.
functiongetPassword()
function
           Represents the password to protect the range.
functiongetSecurityDescriptor()
function
           The security descriptor defines user accounts who may edit this range without providing a password to access the range.
 
Method Summary
functionaddArea(startRow, startColumn, endRow, endColumn)
Adds a referred area to this
functiongetAreas()
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.
      • 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.