com.aspose.cells
Class Protection

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

public class Protection 
extends java.lang.Object

//Instantiating a Workbook object
Workbook workbook = new Workbook();

Worksheet worksheet = workbook.getWorksheets().get(0);
//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);

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.

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.

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.

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.

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.

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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.

public boolean isProtectedWithPassword()

Indicates whether the worksheets is protected with password.

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

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

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.

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

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

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.

public void copy(Protection source)

Copy protection info.

Parameters:

source -

public int getPasswordHash()

Gets the hash of current password.

public boolean verifyPassword(java.lang.String password)

Verifies password.

Parameters:

password - The password.

Returns: