Protection
Inheritance: java.lang.Object
public class Protection
Represents the various types of protection options available for a worksheet.
Example
//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);
Methods
| Method | Description |
|---|---|
| copy(Protection source) | Copy protection info. |
| equals(Object arg0) | |
| getAllowDeletingColumn() | Represents if the deletion of columns is allowed on a protected worksheet. |
| getAllowDeletingRow() | Represents if the deletion of rows is allowed on a protected worksheet. |
| getAllowEditingContent() | Represents if the user is allowed to edit contents of locked cells on a protected worksheet. |
| getAllowEditingObject() | Represents if the user is allowed to manipulate drawing objects on a protected worksheet. |
| getAllowEditingScenario() | Represents if the user is allowed to edit scenarios on a protected worksheet. |
| getAllowFiltering() | Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. |
| getAllowFormattingCell() | Represents if the formatting of cells is allowed on a protected worksheet. |
| getAllowFormattingColumn() | Represents if the formatting of columns is allowed on a protected worksheet |
| getAllowFormattingRow() | Represents if the formatting of rows is allowed on a protected worksheet |
| getAllowInsertingColumn() | Represents if the insertion of columns is allowed on a protected worksheet |
| getAllowInsertingHyperlink() | Represents if the insertion of hyperlinks is allowed on a protected worksheet |
| getAllowInsertingRow() | Represents if the insertion of rows is allowed on a protected worksheet |
| getAllowSelectingLockedCell() | Represents if the user is allowed to select locked cells on a protected worksheet. |
| getAllowSelectingUnlockedCell() | Represents if the user is allowed to select unlocked cells on a protected worksheet. |
| getAllowSorting() | Represents if the sorting option is allowed on a protected worksheet. |
| getAllowUsingPivotTable() | Represents if the user is allowed to manipulate pivot tables on a protected worksheet. |
| getClass() | |
| getPassword() | Represents the password to protect the worksheet. |
| getPasswordHash() | Gets the hash of current password. |
| hashCode() | |
| isDeletingColumnsAllowed() | Represents if the deletion of columns is allowed on a protected worksheet. |
| isDeletingRowsAllowed() | Represents if the deletion of rows is allowed on a protected worksheet. |
| isEditingContentsAllowed() | Represents if the user is allowed to edit contents of locked cells on a protected worksheet. |
| isEditingObjectsAllowed() | Represents if the user is allowed to manipulate drawing objects on a protected worksheet. |
| isEditingScenariosAllowed() | Represents if the user is allowed to edit scenarios on a protected worksheet. |
| isFilteringAllowed() | Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. |
| isFormattingCellsAllowed() | Represents if the formatting of cells is allowed on a protected worksheet. |
| isFormattingColumnsAllowed() | Represents if the formatting of columns is allowed on a protected worksheet |
| isFormattingRowsAllowed() | Represents if the formatting of rows is allowed on a protected worksheet |
| isInsertingColumnsAllowed() | Represents if the insertion of columns is allowed on a protected worksheet |
| isInsertingHyperlinksAllowed() | Represents if the insertion of hyperlinks is allowed on a protected worksheet |
| isInsertingRowsAllowed() | Represents if the insertion of rows is allowed on a protected worksheet |
| isProtectedWithPassword() | Indicates whether the worksheets is protected with password. |
| isSelectingLockedCellsAllowed() | Represents if the user is allowed to select locked cells on a protected worksheet. |
| isSelectingUnlockedCellsAllowed() | Represents if the user is allowed to select unlocked cells on a protected worksheet. |
| isSortingAllowed() | Represents if the sorting option is allowed on a protected worksheet. |
| isUsingPivotTablesAllowed() | Represents if the user is allowed to manipulate pivot tables on a protected worksheet. |
| notify() | |
| notifyAll() | |
| setAllowDeletingColumn(boolean value) | Represents if the deletion of columns is allowed on a protected worksheet. |
| setAllowDeletingRow(boolean value) | Represents if the deletion of rows is allowed on a protected worksheet. |
| setAllowEditingContent(boolean value) | Represents if the user is allowed to edit contents of locked cells on a protected worksheet. |
| setAllowEditingObject(boolean value) | Represents if the user is allowed to manipulate drawing objects on a protected worksheet. |
| setAllowEditingScenario(boolean value) | Represents if the user is allowed to edit scenarios on a protected worksheet. |
| setAllowFiltering(boolean value) | Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. |
| setAllowFormattingCell(boolean value) | Represents if the formatting of cells is allowed on a protected worksheet. |
| setAllowFormattingColumn(boolean value) | Represents if the formatting of columns is allowed on a protected worksheet |
| setAllowFormattingRow(boolean value) | Represents if the formatting of rows is allowed on a protected worksheet |
| setAllowInsertingColumn(boolean value) | Represents if the insertion of columns is allowed on a protected worksheet |
| setAllowInsertingHyperlink(boolean value) | Represents if the insertion of hyperlinks is allowed on a protected worksheet |
| setAllowInsertingRow(boolean value) | Represents if the insertion of rows is allowed on a protected worksheet |
| setAllowSelectingLockedCell(boolean value) | Represents if the user is allowed to select locked cells on a protected worksheet. |
| setAllowSelectingUnlockedCell(boolean value) | Represents if the user is allowed to select unlocked cells on a protected worksheet. |
| setAllowSorting(boolean value) | Represents if the sorting option is allowed on a protected worksheet. |
| setAllowUsingPivotTable(boolean value) | Represents if the user is allowed to manipulate pivot tables on a protected worksheet. |
| setDeletingColumnsAllowed(boolean value) | Represents if the deletion of columns is allowed on a protected worksheet. |
| setDeletingRowsAllowed(boolean value) | Represents if the deletion of rows is allowed on a protected worksheet. |
| setEditingContentsAllowed(boolean value) | Represents if the user is allowed to edit contents of locked cells on a protected worksheet. |
| setEditingObjectsAllowed(boolean value) | Represents if the user is allowed to manipulate drawing objects on a protected worksheet. |
| setEditingScenariosAllowed(boolean value) | Represents if the user is allowed to edit scenarios on a protected worksheet. |
| setFilteringAllowed(boolean value) | Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. |
| setFormattingCellsAllowed(boolean value) | Represents if the formatting of cells is allowed on a protected worksheet. |
| setFormattingColumnsAllowed(boolean value) | Represents if the formatting of columns is allowed on a protected worksheet |
| setFormattingRowsAllowed(boolean value) | Represents if the formatting of rows is allowed on a protected worksheet |
| setInsertingColumnsAllowed(boolean value) | Represents if the insertion of columns is allowed on a protected worksheet |
| setInsertingHyperlinksAllowed(boolean value) | Represents if the insertion of hyperlinks is allowed on a protected worksheet |
| setInsertingRowsAllowed(boolean value) | Represents if the insertion of rows is allowed on a protected worksheet |
| setPassword(String value) | Represents the password to protect the worksheet. |
| setSelectingLockedCellsAllowed(boolean value) | Represents if the user is allowed to select locked cells on a protected worksheet. |
| setSelectingUnlockedCellsAllowed(boolean value) | Represents if the user is allowed to select unlocked cells on a protected worksheet. |
| setSortingAllowed(boolean value) | Represents if the sorting option is allowed on a protected worksheet. |
| setUsingPivotTablesAllowed(boolean value) | Represents if the user is allowed to manipulate pivot tables on a protected worksheet. |
| toString() | |
| verifyPassword(String password) | Verifies password. |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
copy(Protection source)
public void copy(Protection source)
Copy protection info.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| source | Protection |
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getAllowDeletingColumn()
public boolean getAllowDeletingColumn()
Represents if the deletion of columns is allowed on a protected worksheet.
Remarks
The columns containing the cells to be deleted must be unlocked when the sheet is protected, and “Select unlocked cells” option must be enabled.
Returns: boolean
getAllowDeletingRow()
public boolean getAllowDeletingRow()
Represents if the deletion of rows is allowed on a protected worksheet.
Remarks
The rows containing the cells to be deleted must be unlocked when the sheet is protected, and “Select unlocked cells” option must be enabled.
Returns: boolean
getAllowEditingContent()
public boolean getAllowEditingContent()
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Returns: boolean
getAllowEditingObject()
public boolean getAllowEditingObject()
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Returns: boolean
getAllowEditingScenario()
public boolean getAllowEditingScenario()
Represents if the user is allowed to edit scenarios on a protected worksheet.
Returns: boolean
getAllowFiltering()
public boolean getAllowFiltering()
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
Returns: boolean
getAllowFormattingCell()
public boolean getAllowFormattingCell()
Represents if the formatting of cells is allowed on a protected worksheet.
Returns: boolean
getAllowFormattingColumn()
public boolean getAllowFormattingColumn()
Represents if the formatting of columns is allowed on a protected worksheet
Returns: boolean
getAllowFormattingRow()
public boolean getAllowFormattingRow()
Represents if the formatting of rows is allowed on a protected worksheet
Returns: boolean
getAllowInsertingColumn()
public boolean getAllowInsertingColumn()
Represents if the insertion of columns is allowed on a protected worksheet
Returns: boolean
getAllowInsertingHyperlink()
public boolean getAllowInsertingHyperlink()
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Returns: boolean
getAllowInsertingRow()
public boolean getAllowInsertingRow()
Represents if the insertion of rows is allowed on a protected worksheet
Returns: boolean
getAllowSelectingLockedCell()
public boolean getAllowSelectingLockedCell()
Represents if the user is allowed to select locked cells on a protected worksheet.
Returns: boolean
getAllowSelectingUnlockedCell()
public boolean getAllowSelectingUnlockedCell()
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Returns: boolean
getAllowSorting()
public boolean getAllowSorting()
Represents if the sorting option is allowed on a protected worksheet.
Returns: boolean
getAllowUsingPivotTable()
public boolean getAllowUsingPivotTable()
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getPassword()
public String getPassword()
Represents the password to protect the worksheet.
Remarks
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.
Returns: java.lang.String
getPasswordHash()
public int getPasswordHash()
Gets the hash of current password.
Returns: int
hashCode()
public native int hashCode()
Returns: int
isDeletingColumnsAllowed()
public boolean isDeletingColumnsAllowed()
Represents if the deletion of columns is allowed on a protected worksheet.
Remarks
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.
Returns: boolean
isDeletingRowsAllowed()
public boolean isDeletingRowsAllowed()
Represents if the deletion of rows is allowed on a protected worksheet.
Remarks
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.
Returns: boolean
isEditingContentsAllowed()
public boolean isEditingContentsAllowed()
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Remarks
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.
Returns: boolean
isEditingObjectsAllowed()
public boolean isEditingObjectsAllowed()
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Remarks
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.
Returns: boolean
isEditingScenariosAllowed()
public boolean isEditingScenariosAllowed()
Represents if the user is allowed to edit scenarios on a protected worksheet.
Remarks
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.
Returns: boolean
isFilteringAllowed()
public boolean isFilteringAllowed()
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
Remarks
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.
Returns: boolean
isFormattingCellsAllowed()
public boolean isFormattingCellsAllowed()
Represents if the formatting of cells is allowed on a protected worksheet.
Remarks
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.
Returns: boolean
isFormattingColumnsAllowed()
public boolean isFormattingColumnsAllowed()
Represents if the formatting of columns is allowed on a protected worksheet
Remarks
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.
Returns: boolean
isFormattingRowsAllowed()
public boolean isFormattingRowsAllowed()
Represents if the formatting of rows is allowed on a protected worksheet
Remarks
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.
Returns: boolean
isInsertingColumnsAllowed()
public boolean isInsertingColumnsAllowed()
Represents if the insertion of columns is allowed on a protected worksheet
Remarks
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.
Returns: boolean
isInsertingHyperlinksAllowed()
public boolean isInsertingHyperlinksAllowed()
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Remarks
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.
Returns: boolean
isInsertingRowsAllowed()
public boolean isInsertingRowsAllowed()
Represents if the insertion of rows is allowed on a protected worksheet
Remarks
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.
Returns: boolean
isProtectedWithPassword()
public boolean isProtectedWithPassword()
Indicates whether the worksheets is protected with password.
Returns: boolean
isSelectingLockedCellsAllowed()
public boolean isSelectingLockedCellsAllowed()
Represents if the user is allowed to select locked cells on a protected worksheet.
Remarks
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.
Returns: boolean
isSelectingUnlockedCellsAllowed()
public boolean isSelectingUnlockedCellsAllowed()
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Remarks
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.
Returns: boolean
isSortingAllowed()
public boolean isSortingAllowed()
Represents if the sorting option is allowed on a protected worksheet.
Remarks
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.
Returns: boolean
isUsingPivotTablesAllowed()
public boolean isUsingPivotTablesAllowed()
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Remarks
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.
Returns: boolean
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setAllowDeletingColumn(boolean value)
public void setAllowDeletingColumn(boolean value)
Represents if the deletion of columns is allowed on a protected worksheet.
Remarks
The columns containing the cells to be deleted must be unlocked when the sheet is protected, and “Select unlocked cells” option must be enabled.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowDeletingRow(boolean value)
public void setAllowDeletingRow(boolean value)
Represents if the deletion of rows is allowed on a protected worksheet.
Remarks
The rows containing the cells to be deleted must be unlocked when the sheet is protected, and “Select unlocked cells” option must be enabled.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowEditingContent(boolean value)
public void setAllowEditingContent(boolean value)
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowEditingObject(boolean value)
public void setAllowEditingObject(boolean value)
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowEditingScenario(boolean value)
public void setAllowEditingScenario(boolean value)
Represents if the user is allowed to edit scenarios on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowFiltering(boolean value)
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowFormattingCell(boolean value)
public void setAllowFormattingCell(boolean value)
Represents if the formatting of cells is allowed on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowFormattingColumn(boolean value)
public void setAllowFormattingColumn(boolean value)
Represents if the formatting of columns is allowed on a protected worksheet
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowFormattingRow(boolean value)
public void setAllowFormattingRow(boolean value)
Represents if the formatting of rows is allowed on a protected worksheet
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowInsertingColumn(boolean value)
public void setAllowInsertingColumn(boolean value)
Represents if the insertion of columns is allowed on a protected worksheet
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowInsertingHyperlink(boolean value)
public void setAllowInsertingHyperlink(boolean value)
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowInsertingRow(boolean value)
public void setAllowInsertingRow(boolean value)
Represents if the insertion of rows is allowed on a protected worksheet
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowSelectingLockedCell(boolean value)
public void setAllowSelectingLockedCell(boolean value)
Represents if the user is allowed to select locked cells on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowSelectingUnlockedCell(boolean value)
public void setAllowSelectingUnlockedCell(boolean value)
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowSorting(boolean value)
public void setAllowSorting(boolean value)
Represents if the sorting option is allowed on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAllowUsingPivotTable(boolean value)
public void setAllowUsingPivotTable(boolean value)
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setDeletingColumnsAllowed(boolean value)
public void setDeletingColumnsAllowed(boolean value)
Represents if the deletion of columns is allowed on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setDeletingRowsAllowed(boolean value)
public void setDeletingRowsAllowed(boolean value)
Represents if the deletion of rows is allowed on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEditingContentsAllowed(boolean value)
public void setEditingContentsAllowed(boolean value)
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEditingObjectsAllowed(boolean value)
public void setEditingObjectsAllowed(boolean value)
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEditingScenariosAllowed(boolean value)
public void setEditingScenariosAllowed(boolean value)
Represents if the user is allowed to edit scenarios on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setFilteringAllowed(boolean value)
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.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setFormattingCellsAllowed(boolean value)
public void setFormattingCellsAllowed(boolean value)
Represents if the formatting of cells is allowed on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setFormattingColumnsAllowed(boolean value)
public void setFormattingColumnsAllowed(boolean value)
Represents if the formatting of columns is allowed on a protected worksheet
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setFormattingRowsAllowed(boolean value)
public void setFormattingRowsAllowed(boolean value)
Represents if the formatting of rows is allowed on a protected worksheet
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setInsertingColumnsAllowed(boolean value)
public void setInsertingColumnsAllowed(boolean value)
Represents if the insertion of columns is allowed on a protected worksheet
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setInsertingHyperlinksAllowed(boolean value)
public void setInsertingHyperlinksAllowed(boolean value)
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setInsertingRowsAllowed(boolean value)
public void setInsertingRowsAllowed(boolean value)
Represents if the insertion of rows is allowed on a protected worksheet
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setPassword(String value)
public void setPassword(String value)
Represents the password to protect the worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
setSelectingLockedCellsAllowed(boolean value)
public void setSelectingLockedCellsAllowed(boolean value)
Represents if the user is allowed to select locked cells on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setSelectingUnlockedCellsAllowed(boolean value)
public void setSelectingUnlockedCellsAllowed(boolean value)
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setSortingAllowed(boolean value)
public void setSortingAllowed(boolean value)
Represents if the sorting option is allowed on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setUsingPivotTablesAllowed(boolean value)
public void setUsingPivotTablesAllowed(boolean value)
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Remarks
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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
toString()
public String toString()
Returns: java.lang.String
verifyPassword(String password)
public boolean verifyPassword(String password)
Verifies password.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| password | java.lang.String | The password. |
Returns: boolean -
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |