com.aspose.cells

Classes

Interfaces

Constants

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. Only used in ExcelXP and above version.

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

- 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.
  - 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.
  - 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.
  - 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.
  - 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.
  - 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.
  - getAllowFormattingCell/setAllowFormattingCell
```
public boolean getAllowFormattingCell() / 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.
  - getAllowFormattingColumn/setAllowFormattingColumn
```
public boolean getAllowFormattingColumn() / 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.
  - getAllowFormattingRow/setAllowFormattingRow
```
public boolean getAllowFormattingRow() / 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.
  - getAllowInsertingColumn/setAllowInsertingColumn
```
public boolean getAllowInsertingColumn() / 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.
  - getAllowInsertingHyperlink/setAllowInsertingHyperlink
```
public boolean getAllowInsertingHyperlink() / 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.
  - getAllowInsertingRow/setAllowInsertingRow
```
public boolean getAllowInsertingRow() / 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.
  - getAllowSorting/setAllowSorting
```
public boolean getAllowSorting() / 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.
  - getAllowUsingPivotTable/setAllowUsingPivotTable
```
public boolean getAllowUsingPivotTable() / 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.
  - 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.
  - 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.
  - getAllowEditingObject/setAllowEditingObject
```
public boolean getAllowEditingObject() / 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.
  - getAllowEditingScenario/setAllowEditingScenario
```
public boolean getAllowEditingScenario() / 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.
  - 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.
  - 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.
  - 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.
  - getAllowSelectingUnlockedCell/setAllowSelectingUnlockedCell
```
public boolean getAllowSelectingUnlockedCell() / 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.
setAllowDeletingColumn
public voidsetAllowDeletingColumn(booleanvalue)
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.
setDeletingColumnsAllowed
public voidsetDeletingColumnsAllowed(booleanvalue)
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.
setAllowDeletingRow
public voidsetAllowDeletingRow(booleanvalue)
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.
setDeletingRowsAllowed
public voidsetDeletingRowsAllowed(booleanvalue)
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.
setAllowFiltering
public voidsetAllowFiltering(booleanvalue)
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
setFilteringAllowed
public voidsetFilteringAllowed(booleanvalue)
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.
setAllowFormattingCell
public voidsetAllowFormattingCell(booleanvalue)
Represents if the formatting of cells is allowed on a protected worksheet.
setFormattingCellsAllowed
public voidsetFormattingCellsAllowed(booleanvalue)
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.
setAllowFormattingColumn
public voidsetAllowFormattingColumn(booleanvalue)
Represents if the formatting of columns is allowed on a protected worksheet
setFormattingColumnsAllowed
public voidsetFormattingColumnsAllowed(booleanvalue)
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.
setAllowFormattingRow
public voidsetAllowFormattingRow(booleanvalue)
Represents if the formatting of rows is allowed on a protected worksheet
setFormattingRowsAllowed
public voidsetFormattingRowsAllowed(booleanvalue)
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.
setAllowInsertingColumn
public voidsetAllowInsertingColumn(booleanvalue)
Represents if the insertion of columns is allowed on a protected worksheet
setInsertingColumnsAllowed
public voidsetInsertingColumnsAllowed(booleanvalue)
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.
setAllowInsertingHyperlink
public voidsetAllowInsertingHyperlink(booleanvalue)
Represents if the insertion of hyperlinks is allowed on a protected worksheet
setInsertingHyperlinksAllowed
public voidsetInsertingHyperlinksAllowed(booleanvalue)
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.
setAllowInsertingRow
public voidsetAllowInsertingRow(booleanvalue)
Represents if the insertion of rows is allowed on a protected worksheet
setInsertingRowsAllowed
public voidsetInsertingRowsAllowed(booleanvalue)
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.
setAllowSorting
public voidsetAllowSorting(booleanvalue)
Represents if the sorting option is allowed on a protected worksheet.
setSortingAllowed
public voidsetSortingAllowed(booleanvalue)
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.
setAllowUsingPivotTable
public voidsetAllowUsingPivotTable(booleanvalue)
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
setUsingPivotTablesAllowed
public voidsetUsingPivotTablesAllowed(booleanvalue)
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.
setAllowEditingContent
public voidsetAllowEditingContent(booleanvalue)
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
setEditingContentsAllowed
public voidsetEditingContentsAllowed(booleanvalue)
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.
setAllowEditingObject
public voidsetAllowEditingObject(booleanvalue)
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
setEditingObjectsAllowed
public voidsetEditingObjectsAllowed(booleanvalue)
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.
setAllowEditingScenario
public voidsetAllowEditingScenario(booleanvalue)
Represents if the user is allowed to edit scenarios on a protected worksheet.
setEditingScenariosAllowed
public voidsetEditingScenariosAllowed(booleanvalue)
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.
setPassword
public voidsetPassword(java.lang.Stringvalue)
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.
setAllowSelectingLockedCell
public voidsetAllowSelectingLockedCell(booleanvalue)
Represents if the user is allowed to select locked cells on a protected worksheet.
setSelectingLockedCellsAllowed
public voidsetSelectingLockedCellsAllowed(booleanvalue)
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.
setAllowSelectingUnlockedCell
public voidsetAllowSelectingUnlockedCell(booleanvalue)
Represents if the user is allowed to select unlocked cells on a protected worksheet.
setSelectingUnlockedCellsAllowed
public voidsetSelectingUnlockedCellsAllowed(booleanvalue)
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:

setAllowDeletingColumn
public voidsetAllowDeletingColumn(booleanvalue)

setDeletingColumnsAllowed
public voidsetDeletingColumnsAllowed(booleanvalue)

setAllowDeletingRow
public voidsetAllowDeletingRow(booleanvalue)

setDeletingRowsAllowed
public voidsetDeletingRowsAllowed(booleanvalue)

setFilteringAllowed
public voidsetFilteringAllowed(booleanvalue)

setAllowFormattingCell
public voidsetAllowFormattingCell(booleanvalue)

setFormattingCellsAllowed
public voidsetFormattingCellsAllowed(booleanvalue)

setAllowFormattingColumn
public voidsetAllowFormattingColumn(booleanvalue)

setFormattingColumnsAllowed
public voidsetFormattingColumnsAllowed(booleanvalue)

setAllowFormattingRow
public voidsetAllowFormattingRow(booleanvalue)

setAllowFiltering
public voidsetAllowFiltering(booleanvalue)

setFormattingRowsAllowed
public voidsetFormattingRowsAllowed(booleanvalue)

setAllowInsertingColumn
public voidsetAllowInsertingColumn(booleanvalue)

setInsertingColumnsAllowed
public voidsetInsertingColumnsAllowed(booleanvalue)

setAllowInsertingHyperlink
public voidsetAllowInsertingHyperlink(booleanvalue)

setInsertingHyperlinksAllowed
public voidsetInsertingHyperlinksAllowed(booleanvalue)

setAllowInsertingRow
public voidsetAllowInsertingRow(booleanvalue)

setInsertingRowsAllowed
public voidsetInsertingRowsAllowed(booleanvalue)

setAllowUsingPivotTable
public voidsetAllowUsingPivotTable(booleanvalue)

setUsingPivotTablesAllowed
public voidsetUsingPivotTablesAllowed(booleanvalue)

setAllowEditingContent
public voidsetAllowEditingContent(booleanvalue)

setEditingContentsAllowed
public voidsetEditingContentsAllowed(booleanvalue)

setAllowEditingObject
public voidsetAllowEditingObject(booleanvalue)

setEditingObjectsAllowed
public voidsetEditingObjectsAllowed(booleanvalue)

com.aspose.cells

Classes

Interfaces

Constants

Class Protection

Property Getters/Setters Detail

getAllowDeletingColumn/setAllowDeletingColumn

isDeletingColumnsAllowed/setDeletingColumnsAllowed

getAllowDeletingRow/setAllowDeletingRow

isDeletingRowsAllowed/setDeletingRowsAllowed

getAllowFiltering/setAllowFiltering

isFilteringAllowed/setFilteringAllowed

getAllowFormattingCell/setAllowFormattingCell

isFormattingCellsAllowed/setFormattingCellsAllowed

getAllowFormattingColumn/setAllowFormattingColumn

isFormattingColumnsAllowed/setFormattingColumnsAllowed

getAllowFormattingRow/setAllowFormattingRow

isFormattingRowsAllowed/setFormattingRowsAllowed

getAllowInsertingColumn/setAllowInsertingColumn

isInsertingColumnsAllowed/setInsertingColumnsAllowed

getAllowInsertingHyperlink/setAllowInsertingHyperlink

isInsertingHyperlinksAllowed/setInsertingHyperlinksAllowed

getAllowInsertingRow/setAllowInsertingRow

isInsertingRowsAllowed/setInsertingRowsAllowed

getAllowSorting/setAllowSorting

isSortingAllowed/setSortingAllowed

getAllowUsingPivotTable/setAllowUsingPivotTable

isUsingPivotTablesAllowed/setUsingPivotTablesAllowed

getAllowEditingContent/setAllowEditingContent

isEditingContentsAllowed/setEditingContentsAllowed

getAllowEditingObject/setAllowEditingObject

isEditingObjectsAllowed/setEditingObjectsAllowed

getAllowEditingScenario/setAllowEditingScenario

isEditingScenariosAllowed/setEditingScenariosAllowed

getPassword/setPassword

isProtectedWithPassword

getAllowSelectingLockedCell/setAllowSelectingLockedCell

isSelectingLockedCellsAllowed/setSelectingLockedCellsAllowed

getAllowSelectingUnlockedCell/setAllowSelectingUnlockedCell

isSelectingUnlockedCellsAllowed/setSelectingUnlockedCellsAllowed

setAllowDeletingColumn

setDeletingColumnsAllowed

setAllowDeletingRow

setDeletingRowsAllowed

setAllowFiltering

setFilteringAllowed

setAllowFormattingCell

setFormattingCellsAllowed

setAllowFormattingColumn

setFormattingColumnsAllowed

setAllowFormattingRow

setFormattingRowsAllowed

setAllowInsertingColumn

setInsertingColumnsAllowed

setAllowInsertingHyperlink

setInsertingHyperlinksAllowed

setAllowInsertingRow

setInsertingRowsAllowed

setAllowSorting

setSortingAllowed

setAllowUsingPivotTable

setUsingPivotTablesAllowed

setAllowEditingContent

setEditingContentsAllowed

setAllowEditingObject

setEditingObjectsAllowed

setAllowEditingScenario

setEditingScenariosAllowed

setPassword

setAllowSelectingLockedCell

setSelectingLockedCellsAllowed

setAllowSelectingUnlockedCell

setSelectingUnlockedCellsAllowed

Method Detail

copy

getPasswordHash

verifyPassword

setAllowEditingScenario
public voidsetAllowEditingScenario(booleanvalue)

setEditingScenariosAllowed
public voidsetEditingScenariosAllowed(booleanvalue)

setAllowSelectingLockedCell
public voidsetAllowSelectingLockedCell(booleanvalue)

setSelectingLockedCellsAllowed
public voidsetSelectingLockedCellsAllowed(booleanvalue)

setAllowSelectingUnlockedCell
public voidsetAllowSelectingUnlockedCell(booleanvalue)

setSelectingUnlockedCellsAllowed
public voidsetSelectingUnlockedCellsAllowed(booleanvalue)