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.
functionisProtectedWithPassword()
Indicates whether the worksheets is protected with password.
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.
      • 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.