asposecells.api

Class ProtectedRange

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

Property Getters/Setters Summary
methodgetCellArea()
Gets the CellArea object represents the cell area to be protected.
methodisProtectedWithPassword()
Indicates whether the worksheets is protected with password.
methodgetName()
method
setName(value)
           Gets the Range title. This is used as a descriptor, not as a named range definition.
methodgetPassword()
method
           Represents the password to protect the range.
methodgetSecurityDescriptor()
method
           The security descriptor defines user accounts who may edit this range without providing a password to access the range.
 
Method Summary
methodaddArea(startRow, startColumn, endRow, endColumn)
Adds a referred area to this
methodgetAreas()
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.