com.aspose.cells.Protection.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






Protection





com.aspose.cells

Class Protection
java.lang.Object
    com.aspose.cells.Protection



public class Protection extends java.lang.Object





            Represents the various types of protection options available for a worksheet. 
            
Example:
//Allowing users to select locked cells of the worksheet
worksheet.getProtection().setAllowSelectingLockedCell(true);
//Allowing users to select unlocked cells of the worksheet
worksheet.getProtection().setAllowSelectingUnlockedCell(true);












Property Getters/Setters Summary



boolean getAllowDeletingColumn() 
void setAllowDeletingColumn(boolean) 
          
            Represents if the deletion of columns is allowed on a protected worksheet.
            



boolean getAllowDeletingRow() 
void setAllowDeletingRow(boolean) 
          
            Represents if the deletion of rows is allowed on a protected worksheet.
            



boolean getAllowEditingContent() 
void setAllowEditingContent(boolean) 
          
            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            



boolean getAllowEditingObject() 
void setAllowEditingObject(boolean) 
          
            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            



boolean getAllowEditingScenario() 
void setAllowEditingScenario(boolean) 
          
            Represents if the user is allowed to edit scenarios on a protected worksheet.
            



boolean getAllowFiltering() 
void setAllowFiltering(boolean) 
          
            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            



boolean getAllowFormattingCell() 
void setAllowFormattingCell(boolean) 
          
            Represents if the formatting of cells is allowed on a protected worksheet.
            



boolean getAllowFormattingColumn() 
void setAllowFormattingColumn(boolean) 
          
            Represents if the formatting of columns is allowed on a protected worksheet
            



boolean getAllowFormattingRow() 
void setAllowFormattingRow(boolean) 
          
            Represents if the formatting of rows is allowed on a protected worksheet
            



boolean getAllowInsertingColumn() 
void setAllowInsertingColumn(boolean) 
          
            Represents if the insertion of columns is allowed on a protected worksheet
            



boolean getAllowInsertingHyperlink() 
void setAllowInsertingHyperlink(boolean) 
          
            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            



boolean getAllowInsertingRow() 
void setAllowInsertingRow(boolean) 
          
            Represents if the insertion of rows is allowed on a protected worksheet
            



boolean getAllowSelectingLockedCell() 
void setAllowSelectingLockedCell(boolean) 
          
            Represents if the user is allowed to select locked cells on a protected worksheet.
            



boolean getAllowSelectingUnlockedCell() 
void setAllowSelectingUnlockedCell(boolean) 
          
            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            



boolean getAllowSorting() 
void setAllowSorting(boolean) 
          
            Represents if the sorting option is allowed on a protected worksheet.
            



boolean getAllowUsingPivotTable() 
void setAllowUsingPivotTable(boolean) 
          
            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            



boolean isDeletingColumnsAllowed() 
void setDeletingColumnsAllowed(boolean) 
          
            Represents if the deletion of columns is allowed on a protected worksheet.
            



boolean isDeletingRowsAllowed() 
void setDeletingRowsAllowed(boolean) 
          
            Represents if the deletion of rows is allowed on a protected worksheet.
            



boolean isEditingContentsAllowed() 
void setEditingContentsAllowed(boolean) 
          
            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            



boolean isEditingObjectsAllowed() 
void setEditingObjectsAllowed(boolean) 
          
            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            



boolean isEditingScenariosAllowed() 
void setEditingScenariosAllowed(boolean) 
          
            Represents if the user is allowed to edit scenarios on a protected worksheet.
            



boolean isFilteringAllowed() 
void setFilteringAllowed(boolean) 
          
            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            



boolean isFormattingCellsAllowed() 
void setFormattingCellsAllowed(boolean) 
          
            Represents if the formatting of cells is allowed on a protected worksheet.
            



boolean isFormattingColumnsAllowed() 
void setFormattingColumnsAllowed(boolean) 
          
            Represents if the formatting of columns is allowed on a protected worksheet
            



boolean isFormattingRowsAllowed() 
void setFormattingRowsAllowed(boolean) 
          
            Represents if the formatting of rows is allowed on a protected worksheet
            



boolean isInsertingColumnsAllowed() 
void setInsertingColumnsAllowed(boolean) 
          
            Represents if the insertion of columns is allowed on a protected worksheet
            



boolean isInsertingHyperlinksAllowed() 
void setInsertingHyperlinksAllowed(boolean) 
          
            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            



boolean isInsertingRowsAllowed() 
void setInsertingRowsAllowed(boolean) 
          
            Represents if the insertion of rows is allowed on a protected worksheet
            



boolean isProtectedWithPassword() 
          
            Indicates whether the worksheets is protected with password.
            



boolean isSelectingLockedCellsAllowed() 
void setSelectingLockedCellsAllowed(boolean) 
          
            Represents if the user is allowed to select locked cells on a protected worksheet.
            



boolean isSelectingUnlockedCellsAllowed() 
void setSelectingUnlockedCellsAllowed(boolean) 
          
            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            



boolean isSortingAllowed() 
void setSortingAllowed(boolean) 
          
            Represents if the sorting option is allowed on a protected worksheet.
            



boolean isUsingPivotTablesAllowed() 
void setUsingPivotTablesAllowed(boolean) 
          
            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            



java.lang.String getPassword() 
void setPassword(java.lang.String) 
          
            Represents the password to protect the worksheet.
            

 







Method Summary




void copy(Protection source) 
          
            Copy protection info.
            




int getPasswordHash() 
          
            Gets the hash of current password.
            




boolean verifyPassword(java.lang.String password) 
          
             Verifies password.
            

 








Property Getters/Setters Detail



getAllowDeletingColumn/setAllowDeletingColumn 
public boolean getAllowDeletingColumn() / public void setAllowDeletingColumn(boolean value)


            Represents if the deletion of columns is allowed on a protected worksheet.
            
The columns containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. 



setAllowDeletingColumn 
public void setAllowDeletingColumn(boolean value)


            Represents if the deletion of columns is allowed on a protected worksheet.
            
The columns containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. 




isDeletingColumnsAllowed/setDeletingColumnsAllowed 
public boolean isDeletingColumnsAllowed() / public void setDeletingColumnsAllowed(boolean value)


            Represents if the deletion of columns is allowed on a protected worksheet.
            
The columns containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowDeletingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setDeletingColumnsAllowed 
public void setDeletingColumnsAllowed(boolean value)


            Represents if the deletion of columns is allowed on a protected worksheet.
            
The columns containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowDeletingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowDeletingRow/setAllowDeletingRow 
public boolean getAllowDeletingRow() / public void setAllowDeletingRow(boolean value)


            Represents if the deletion of rows is allowed on a protected worksheet.
            
The rows containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. 



setAllowDeletingRow 
public void setAllowDeletingRow(boolean value)


            Represents if the deletion of rows is allowed on a protected worksheet.
            
The rows containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. 




isDeletingRowsAllowed/setDeletingRowsAllowed 
public boolean isDeletingRowsAllowed() / public void setDeletingRowsAllowed(boolean value)


            Represents if the deletion of rows is allowed on a protected worksheet.
            
The rows containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowDeletingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setDeletingRowsAllowed 
public void setDeletingRowsAllowed(boolean value)


            Represents if the deletion of rows is allowed on a protected worksheet.
            
The rows containing the cells to be deleted must be unlocked when the sheet is protected,
            and "Select unlocked cells" option must be enabled. NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowDeletingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowFiltering/setAllowFiltering 
public boolean getAllowFiltering() / public void setAllowFiltering(boolean value)


            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            



setAllowFiltering 
public void setAllowFiltering(boolean value)


            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            




isFilteringAllowed/setFilteringAllowed 
public boolean isFilteringAllowed() / public void setFilteringAllowed(boolean value)


            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFiltering property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setFilteringAllowed 
public void setFilteringAllowed(boolean value)


            Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. 
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFiltering property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowFormattingCell/setAllowFormattingCell 
public boolean getAllowFormattingCell() / public void setAllowFormattingCell(boolean value)


            Represents if the formatting of cells is allowed on a protected worksheet.
            



setAllowFormattingCell 
public void setAllowFormattingCell(boolean value)


            Represents if the formatting of cells is allowed on a protected worksheet.
            




isFormattingCellsAllowed/setFormattingCellsAllowed 
public boolean isFormattingCellsAllowed() / public void setFormattingCellsAllowed(boolean value)


            Represents if the formatting of cells is allowed on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setFormattingCellsAllowed 
public void setFormattingCellsAllowed(boolean value)


            Represents if the formatting of cells is allowed on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowFormattingColumn/setAllowFormattingColumn 
public boolean getAllowFormattingColumn() / public void setAllowFormattingColumn(boolean value)


            Represents if the formatting of columns is allowed on a protected worksheet
            



setAllowFormattingColumn 
public void setAllowFormattingColumn(boolean value)


            Represents if the formatting of columns is allowed on a protected worksheet
            




isFormattingColumnsAllowed/setFormattingColumnsAllowed 
public boolean isFormattingColumnsAllowed() / public void setFormattingColumnsAllowed(boolean value)


            Represents if the formatting of columns is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setFormattingColumnsAllowed 
public void setFormattingColumnsAllowed(boolean value)


            Represents if the formatting of columns is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowFormattingRow/setAllowFormattingRow 
public boolean getAllowFormattingRow() / public void setAllowFormattingRow(boolean value)


            Represents if the formatting of rows is allowed on a protected worksheet
            



setAllowFormattingRow 
public void setAllowFormattingRow(boolean value)


            Represents if the formatting of rows is allowed on a protected worksheet
            




isFormattingRowsAllowed/setFormattingRowsAllowed 
public boolean isFormattingRowsAllowed() / public void setFormattingRowsAllowed(boolean value)


            Represents if the formatting of rows is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setFormattingRowsAllowed 
public void setFormattingRowsAllowed(boolean value)


            Represents if the formatting of rows is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowFormattingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowInsertingColumn/setAllowInsertingColumn 
public boolean getAllowInsertingColumn() / public void setAllowInsertingColumn(boolean value)


            Represents if the insertion of columns is allowed on a protected worksheet
            



setAllowInsertingColumn 
public void setAllowInsertingColumn(boolean value)


            Represents if the insertion of columns is allowed on a protected worksheet
            




isInsertingColumnsAllowed/setInsertingColumnsAllowed 
public boolean isInsertingColumnsAllowed() / public void setInsertingColumnsAllowed(boolean value)


            Represents if the insertion of columns is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setInsertingColumnsAllowed 
public void setInsertingColumnsAllowed(boolean value)


            Represents if the insertion of columns is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingColumn property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowInsertingHyperlink/setAllowInsertingHyperlink 
public boolean getAllowInsertingHyperlink() / public void setAllowInsertingHyperlink(boolean value)


            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            



setAllowInsertingHyperlink 
public void setAllowInsertingHyperlink(boolean value)


            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            




isInsertingHyperlinksAllowed/setInsertingHyperlinksAllowed 
public boolean isInsertingHyperlinksAllowed() / public void setInsertingHyperlinksAllowed(boolean value)


            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingHyperlink property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setInsertingHyperlinksAllowed 
public void setInsertingHyperlinksAllowed(boolean value)


            Represents if the insertion of hyperlinks is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingHyperlink property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowInsertingRow/setAllowInsertingRow 
public boolean getAllowInsertingRow() / public void setAllowInsertingRow(boolean value)


            Represents if the insertion of rows is allowed on a protected worksheet
            



setAllowInsertingRow 
public void setAllowInsertingRow(boolean value)


            Represents if the insertion of rows is allowed on a protected worksheet
            




isInsertingRowsAllowed/setInsertingRowsAllowed 
public boolean isInsertingRowsAllowed() / public void setInsertingRowsAllowed(boolean value)


            Represents if the insertion of rows is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setInsertingRowsAllowed 
public void setInsertingRowsAllowed(boolean value)


            Represents if the insertion of rows is allowed on a protected worksheet
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowInsertingRow property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowSorting/setAllowSorting 
public boolean getAllowSorting() / public void setAllowSorting(boolean value)


            Represents if the sorting option is allowed on a protected worksheet.
            



setAllowSorting 
public void setAllowSorting(boolean value)


            Represents if the sorting option is allowed on a protected worksheet.
            




isSortingAllowed/setSortingAllowed 
public boolean isSortingAllowed() / public void setSortingAllowed(boolean value)


            Represents if the sorting option is allowed on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSorting property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setSortingAllowed 
public void setSortingAllowed(boolean value)


            Represents if the sorting option is allowed on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSorting property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowUsingPivotTable/setAllowUsingPivotTable 
public boolean getAllowUsingPivotTable() / public void setAllowUsingPivotTable(boolean value)


            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            



setAllowUsingPivotTable 
public void setAllowUsingPivotTable(boolean value)


            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            




isUsingPivotTablesAllowed/setUsingPivotTablesAllowed 
public boolean isUsingPivotTablesAllowed() / public void setUsingPivotTablesAllowed(boolean value)


            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowUsingPivotTable property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setUsingPivotTablesAllowed 
public void setUsingPivotTablesAllowed(boolean value)


            Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowUsingPivotTable property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowEditingContent/setAllowEditingContent 
public boolean getAllowEditingContent() / public void setAllowEditingContent(boolean value)


            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            



setAllowEditingContent 
public void setAllowEditingContent(boolean value)


            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            




isEditingContentsAllowed/setEditingContentsAllowed 
public boolean isEditingContentsAllowed() / public void setEditingContentsAllowed(boolean value)


            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingContent property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setEditingContentsAllowed 
public void setEditingContentsAllowed(boolean value)


            Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingContent property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowEditingObject/setAllowEditingObject 
public boolean getAllowEditingObject() / public void setAllowEditingObject(boolean value)


            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            



setAllowEditingObject 
public void setAllowEditingObject(boolean value)


            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            




isEditingObjectsAllowed/setEditingObjectsAllowed 
public boolean isEditingObjectsAllowed() / public void setEditingObjectsAllowed(boolean value)


            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingObject property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setEditingObjectsAllowed 
public void setEditingObjectsAllowed(boolean value)


            Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingObject property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowEditingScenario/setAllowEditingScenario 
public boolean getAllowEditingScenario() / public void setAllowEditingScenario(boolean value)


            Represents if the user is allowed to edit scenarios on a protected worksheet.
            



setAllowEditingScenario 
public void setAllowEditingScenario(boolean value)


            Represents if the user is allowed to edit scenarios on a protected worksheet.
            




isEditingScenariosAllowed/setEditingScenariosAllowed 
public boolean isEditingScenariosAllowed() / public void setEditingScenariosAllowed(boolean value)


            Represents if the user is allowed to edit scenarios on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingScenario property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setEditingScenariosAllowed 
public void setEditingScenariosAllowed(boolean value)


            Represents if the user is allowed to edit scenarios on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowEditingScenario property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getPassword/setPassword 
public java.lang.String getPassword() / public void setPassword(java.lang.String value)


            Represents the password to protect the worksheet.
            

            If password is set to null or blank string, you can unprotect the worksheet or workbook without using a password. Otherwise, you must specify the password to unprotect the worksheet or workbook.
            



setPassword 
public void setPassword(java.lang.String value)


            Represents the password to protect the worksheet.
            

            If password is set to null or blank string, you can unprotect the worksheet or workbook without using a password. Otherwise, you must specify the password to unprotect the worksheet or workbook.
            




isProtectedWithPassword 
public boolean isProtectedWithPassword()


            Indicates whether the worksheets is protected with password.
            



getAllowSelectingLockedCell/setAllowSelectingLockedCell 
public boolean getAllowSelectingLockedCell() / public void setAllowSelectingLockedCell(boolean value)


            Represents if the user is allowed to select locked cells on a protected worksheet.
            



setAllowSelectingLockedCell 
public void setAllowSelectingLockedCell(boolean value)


            Represents if the user is allowed to select locked cells on a protected worksheet.
            




isSelectingLockedCellsAllowed/setSelectingLockedCellsAllowed 
public boolean isSelectingLockedCellsAllowed() / public void setSelectingLockedCellsAllowed(boolean value)


            Represents if the user is allowed to select locked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSelectingLockedCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setSelectingLockedCellsAllowed 
public void setSelectingLockedCellsAllowed(boolean value)


            Represents if the user is allowed to select locked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSelectingLockedCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.




getAllowSelectingUnlockedCell/setAllowSelectingUnlockedCell 
public boolean getAllowSelectingUnlockedCell() / public void setAllowSelectingUnlockedCell(boolean value)


            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            



setAllowSelectingUnlockedCell 
public void setAllowSelectingUnlockedCell(boolean value)


            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            




isSelectingUnlockedCellsAllowed/setSelectingUnlockedCellsAllowed 
public boolean isSelectingUnlockedCellsAllowed() / public void setSelectingUnlockedCellsAllowed(boolean value)


            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSelectingUnlockedCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.



setSelectingUnlockedCellsAllowed 
public void setSelectingUnlockedCellsAllowed(boolean value)


            Represents if the user is allowed to select unlocked cells on a protected worksheet.
            
NOTE: This member is now obsolete. Instead, 
            please use Protection.AllowSelectingUnlockedCell property. 
            This property will be removed 12 months later since June 2010. 
            Aspose apologizes for any inconvenience you may have experienced.








Method Detail



copy 
public void copy(Protection source)

            Copy protection info.
            
Parameters:
source - 




getPasswordHash 
public int getPasswordHash()

            Gets the hash of current password.
            




verifyPassword 
public boolean verifyPassword(java.lang.String password)

             Verifies password.
            
Parameters:
password - The password.
Returns:





See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Property Getters/Setters Summary
`boolean`	`getAllowDeletingColumn()`
`void`	`setAllowDeletingColumn(boolean)`
	Represents if the deletion of columns is allowed on a protected worksheet.
`boolean`	`getAllowDeletingRow()`
`void`	`setAllowDeletingRow(boolean)`
	Represents if the deletion of rows is allowed on a protected worksheet.
`boolean`	`getAllowEditingContent()`
`void`	`setAllowEditingContent(boolean)`
	Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
`boolean`	`getAllowEditingObject()`
`void`	`setAllowEditingObject(boolean)`
	Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
`boolean`	`getAllowEditingScenario()`
`void`	`setAllowEditingScenario(boolean)`
	Represents if the user is allowed to edit scenarios on a protected worksheet.
`boolean`	`getAllowFiltering()`
`void`	`setAllowFiltering(boolean)`
	Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
`boolean`	`getAllowFormattingCell()`
`void`	`setAllowFormattingCell(boolean)`
	Represents if the formatting of cells is allowed on a protected worksheet.
`boolean`	`getAllowFormattingColumn()`
`void`	`setAllowFormattingColumn(boolean)`
	Represents if the formatting of columns is allowed on a protected worksheet
`boolean`	`getAllowFormattingRow()`
`void`	`setAllowFormattingRow(boolean)`
	Represents if the formatting of rows is allowed on a protected worksheet
`boolean`	`getAllowInsertingColumn()`
`void`	`setAllowInsertingColumn(boolean)`
	Represents if the insertion of columns is allowed on a protected worksheet
`boolean`	`getAllowInsertingHyperlink()`
`void`	`setAllowInsertingHyperlink(boolean)`
	Represents if the insertion of hyperlinks is allowed on a protected worksheet
`boolean`	`getAllowInsertingRow()`
`void`	`setAllowInsertingRow(boolean)`
	Represents if the insertion of rows is allowed on a protected worksheet
`boolean`	`getAllowSelectingLockedCell()`
`void`	`setAllowSelectingLockedCell(boolean)`
	Represents if the user is allowed to select locked cells on a protected worksheet.
`boolean`	`getAllowSelectingUnlockedCell()`
`void`	`setAllowSelectingUnlockedCell(boolean)`
	Represents if the user is allowed to select unlocked cells on a protected worksheet.
`boolean`	`getAllowSorting()`
`void`	`setAllowSorting(boolean)`
	Represents if the sorting option is allowed on a protected worksheet.
`boolean`	`getAllowUsingPivotTable()`
`void`	`setAllowUsingPivotTable(boolean)`
	Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
`boolean`	`isDeletingColumnsAllowed()`
`void`	`setDeletingColumnsAllowed(boolean)`
	Represents if the deletion of columns is allowed on a protected worksheet.
`boolean`	`isDeletingRowsAllowed()`
`void`	`setDeletingRowsAllowed(boolean)`
	Represents if the deletion of rows is allowed on a protected worksheet.
`boolean`	`isEditingContentsAllowed()`
`void`	`setEditingContentsAllowed(boolean)`
	Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
`boolean`	`isEditingObjectsAllowed()`
`void`	`setEditingObjectsAllowed(boolean)`
	Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
`boolean`	`isEditingScenariosAllowed()`
`void`	`setEditingScenariosAllowed(boolean)`
	Represents if the user is allowed to edit scenarios on a protected worksheet.
`boolean`	`isFilteringAllowed()`
`void`	`setFilteringAllowed(boolean)`
	Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
`boolean`	`isFormattingCellsAllowed()`
`void`	`setFormattingCellsAllowed(boolean)`
	Represents if the formatting of cells is allowed on a protected worksheet.
`boolean`	`isFormattingColumnsAllowed()`
`void`	`setFormattingColumnsAllowed(boolean)`
	Represents if the formatting of columns is allowed on a protected worksheet
`boolean`	`isFormattingRowsAllowed()`
`void`	`setFormattingRowsAllowed(boolean)`
	Represents if the formatting of rows is allowed on a protected worksheet
`boolean`	`isInsertingColumnsAllowed()`
`void`	`setInsertingColumnsAllowed(boolean)`
	Represents if the insertion of columns is allowed on a protected worksheet
`boolean`	`isInsertingHyperlinksAllowed()`
`void`	`setInsertingHyperlinksAllowed(boolean)`
	Represents if the insertion of hyperlinks is allowed on a protected worksheet
`boolean`	`isInsertingRowsAllowed()`
`void`	`setInsertingRowsAllowed(boolean)`
	Represents if the insertion of rows is allowed on a protected worksheet
`boolean`	`isProtectedWithPassword()`
	Indicates whether the worksheets is protected with password.
`boolean`	`isSelectingLockedCellsAllowed()`
`void`	`setSelectingLockedCellsAllowed(boolean)`
	Represents if the user is allowed to select locked cells on a protected worksheet.
`boolean`	`isSelectingUnlockedCellsAllowed()`
`void`	`setSelectingUnlockedCellsAllowed(boolean)`
	Represents if the user is allowed to select unlocked cells on a protected worksheet.
`boolean`	`isSortingAllowed()`
`void`	`setSortingAllowed(boolean)`
	Represents if the sorting option is allowed on a protected worksheet.
`boolean`	`isUsingPivotTablesAllowed()`
`void`	`setUsingPivotTablesAllowed(boolean)`
	Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
`java.lang.String`	`getPassword()`
`void`	`setPassword(java.lang.String)`
	Represents the password to protect the worksheet.

Method Summary
`void`	`copy(Protection source)`
`void`	Copy protection info.
`int`	`getPasswordHash()`
`int`	Gets the hash of current password.
`boolean`	`verifyPassword(java.lang.String password)`
`boolean`	Verifies password.

getAllowDeletingColumn/setAllowDeletingColumn
public boolean getAllowDeletingColumn() / public void setAllowDeletingColumn(boolean value)

setAllowDeletingColumn
public void setAllowDeletingColumn(boolean value)

isDeletingColumnsAllowed/setDeletingColumnsAllowed
public boolean isDeletingColumnsAllowed() / public void setDeletingColumnsAllowed(boolean value)

setDeletingColumnsAllowed
public void setDeletingColumnsAllowed(boolean value)

getAllowDeletingRow/setAllowDeletingRow
public boolean getAllowDeletingRow() / public void setAllowDeletingRow(boolean value)

setAllowDeletingRow
public void setAllowDeletingRow(boolean value)

isDeletingRowsAllowed/setDeletingRowsAllowed
public boolean isDeletingRowsAllowed() / public void setDeletingRowsAllowed(boolean value)

setDeletingRowsAllowed
public void setDeletingRowsAllowed(boolean value)

getAllowFiltering/setAllowFiltering
public boolean getAllowFiltering() / public void setAllowFiltering(boolean value)

setAllowFiltering
public void setAllowFiltering(boolean value)

isFilteringAllowed/setFilteringAllowed
public boolean isFilteringAllowed() / public void setFilteringAllowed(boolean value)

setFilteringAllowed
public void setFilteringAllowed(boolean value)

getAllowFormattingCell/setAllowFormattingCell
public boolean getAllowFormattingCell() / public void setAllowFormattingCell(boolean value)

setAllowFormattingCell
public void setAllowFormattingCell(boolean value)

isFormattingCellsAllowed/setFormattingCellsAllowed
public boolean isFormattingCellsAllowed() / public void setFormattingCellsAllowed(boolean value)

setFormattingCellsAllowed
public void setFormattingCellsAllowed(boolean value)

getAllowFormattingColumn/setAllowFormattingColumn
public boolean getAllowFormattingColumn() / public void setAllowFormattingColumn(boolean value)

setAllowFormattingColumn
public void setAllowFormattingColumn(boolean value)

isFormattingColumnsAllowed/setFormattingColumnsAllowed
public boolean isFormattingColumnsAllowed() / public void setFormattingColumnsAllowed(boolean value)

setFormattingColumnsAllowed
public void setFormattingColumnsAllowed(boolean value)

com.aspose.cells.Protection.html Maven / Gradle / Ivy

com.aspose.cells Class Protection

getAllowDeletingColumn/setAllowDeletingColumn

setAllowDeletingColumn

isDeletingColumnsAllowed/setDeletingColumnsAllowed

setDeletingColumnsAllowed

getAllowDeletingRow/setAllowDeletingRow

setAllowDeletingRow

isDeletingRowsAllowed/setDeletingRowsAllowed

setDeletingRowsAllowed

getAllowFiltering/setAllowFiltering

setAllowFiltering

isFilteringAllowed/setFilteringAllowed

setFilteringAllowed

getAllowFormattingCell/setAllowFormattingCell

setAllowFormattingCell

isFormattingCellsAllowed/setFormattingCellsAllowed

setFormattingCellsAllowed

getAllowFormattingColumn/setAllowFormattingColumn

setAllowFormattingColumn

isFormattingColumnsAllowed/setFormattingColumnsAllowed

setFormattingColumnsAllowed

getAllowFormattingRow/setAllowFormattingRow

setAllowFormattingRow

isFormattingRowsAllowed/setFormattingRowsAllowed

setFormattingRowsAllowed

getAllowInsertingColumn/setAllowInsertingColumn

setAllowInsertingColumn

isInsertingColumnsAllowed/setInsertingColumnsAllowed

setInsertingColumnsAllowed

getAllowInsertingHyperlink/setAllowInsertingHyperlink

setAllowInsertingHyperlink

isInsertingHyperlinksAllowed/setInsertingHyperlinksAllowed

setInsertingHyperlinksAllowed

getAllowInsertingRow/setAllowInsertingRow

setAllowInsertingRow

isInsertingRowsAllowed/setInsertingRowsAllowed

setInsertingRowsAllowed

getAllowSorting/setAllowSorting

setAllowSorting

isSortingAllowed/setSortingAllowed

setSortingAllowed

getAllowUsingPivotTable/setAllowUsingPivotTable

setAllowUsingPivotTable

isUsingPivotTablesAllowed/setUsingPivotTablesAllowed

setUsingPivotTablesAllowed

getAllowEditingContent/setAllowEditingContent

setAllowEditingContent

isEditingContentsAllowed/setEditingContentsAllowed

setEditingContentsAllowed

getAllowEditingObject/setAllowEditingObject

setAllowEditingObject

isEditingObjectsAllowed/setEditingObjectsAllowed

setEditingObjectsAllowed

getAllowEditingScenario/setAllowEditingScenario

setAllowEditingScenario

isEditingScenariosAllowed/setEditingScenariosAllowed

setEditingScenariosAllowed

getPassword/setPassword

setPassword

isProtectedWithPassword

getAllowSelectingLockedCell/setAllowSelectingLockedCell

setAllowSelectingLockedCell

isSelectingLockedCellsAllowed/setSelectingLockedCellsAllowed

setSelectingLockedCellsAllowed

getAllowSelectingUnlockedCell/setAllowSelectingUnlockedCell

setAllowSelectingUnlockedCell

isSelectingUnlockedCellsAllowed/setSelectingUnlockedCellsAllowed

setSelectingUnlockedCellsAllowed

copy

getPasswordHash

verifyPassword

com.aspose.cells
Class Protection

getAllowFormattingRow/setAllowFormattingRow
public boolean getAllowFormattingRow() / public void setAllowFormattingRow(boolean value)

setAllowFormattingRow
public void setAllowFormattingRow(boolean value)

isFormattingRowsAllowed/setFormattingRowsAllowed
public boolean isFormattingRowsAllowed() / public void setFormattingRowsAllowed(boolean value)

setFormattingRowsAllowed
public void setFormattingRowsAllowed(boolean value)

getAllowInsertingColumn/setAllowInsertingColumn
public boolean getAllowInsertingColumn() / public void setAllowInsertingColumn(boolean value)

setAllowInsertingColumn
public void setAllowInsertingColumn(boolean value)

isInsertingColumnsAllowed/setInsertingColumnsAllowed
public boolean isInsertingColumnsAllowed() / public void setInsertingColumnsAllowed(boolean value)

setInsertingColumnsAllowed
public void setInsertingColumnsAllowed(boolean value)

getAllowInsertingHyperlink/setAllowInsertingHyperlink
public boolean getAllowInsertingHyperlink() / public void setAllowInsertingHyperlink(boolean value)

setAllowInsertingHyperlink
public void setAllowInsertingHyperlink(boolean value)