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.
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.
      • 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.