Example:
$workbook = new cells\Workbook(); $worksheet = $workbook->getWorksheets()->get(0); $worksheet->getProtection()->setAllowSelectingLockedCell(false); //Allowing users to select unlocked cells of the worksheet $worksheet->getProtection()->setAllowSelectingUnlockedCell(true);
Property Getters/Setters Summary | ||
---|---|---|
function | getAllowDeletingColumn() | |
function | setAllowDeletingColumn(value) | |
Represents if the deletion of columns is allowed on a protected worksheet. | ||
function | getAllowDeletingRow() | |
function | setAllowDeletingRow(value) | |
Represents if the deletion of rows is allowed on a protected worksheet. | ||
function | getAllowEditingContent() | |
function | setAllowEditingContent(value) | |
Represents if the user is allowed to edit contents of locked cells on a protected worksheet. | ||
function | getAllowEditingObject() | |
function | setAllowEditingObject(value) | |
Represents if the user is allowed to manipulate drawing objects on a protected worksheet. | ||
function | getAllowEditingScenario() | |
function | setAllowEditingScenario(value) | |
Represents if the user is allowed to edit scenarios on a protected worksheet. | ||
function | getAllowFiltering() | |
function | setAllowFiltering(value) | |
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. | ||
function | getAllowFormattingCell() | |
function | setAllowFormattingCell(value) | |
Represents if the formatting of cells is allowed on a protected worksheet. | ||
function | getAllowFormattingColumn() | |
function | setAllowFormattingColumn(value) | |
Represents if the formatting of columns is allowed on a protected worksheet | ||
function | getAllowFormattingRow() | |
function | setAllowFormattingRow(value) | |
Represents if the formatting of rows is allowed on a protected worksheet | ||
function | getAllowInsertingColumn() | |
function | setAllowInsertingColumn(value) | |
Represents if the insertion of columns is allowed on a protected worksheet | ||
function | getAllowInsertingHyperlink() | |
function | setAllowInsertingHyperlink(value) | |
Represents if the insertion of hyperlinks is allowed on a protected worksheet | ||
function | getAllowInsertingRow() | |
function | setAllowInsertingRow(value) | |
Represents if the insertion of rows is allowed on a protected worksheet | ||
function | getAllowSelectingLockedCell() | |
function | setAllowSelectingLockedCell(value) | |
Represents if the user is allowed to select locked cells on a protected worksheet. | ||
function | getAllowSelectingUnlockedCell() | |
function | setAllowSelectingUnlockedCell(value) | |
Represents if the user is allowed to select unlocked cells on a protected worksheet. | ||
function | getAllowSorting() | |
function | setAllowSorting(value) | |
Represents if the sorting option is allowed on a protected worksheet. | ||
function | getAllowUsingPivotTable() | |
function | setAllowUsingPivotTable(value) | |
Represents if the user is allowed to manipulate pivot tables on a protected worksheet. | ||
function | isDeletingColumnsAllowed() | |
function | setDeletingColumnsAllowed(value) | |
Represents if the deletion of columns is allowed on a protected worksheet. | ||
function | isDeletingRowsAllowed() | |
function | setDeletingRowsAllowed(value) | |
Represents if the deletion of rows is allowed on a protected worksheet. | ||
function | isEditingContentsAllowed() | |
function | setEditingContentsAllowed(value) | |
Represents if the user is allowed to edit contents of locked cells on a protected worksheet. | ||
function | isEditingObjectsAllowed() | |
function | setEditingObjectsAllowed(value) | |
Represents if the user is allowed to manipulate drawing objects on a protected worksheet. | ||
function | isEditingScenariosAllowed() | |
function | setEditingScenariosAllowed(value) | |
Represents if the user is allowed to edit scenarios on a protected worksheet. | ||
function | isFilteringAllowed() | |
function | setFilteringAllowed(value) | |
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. | ||
function | isFormattingCellsAllowed() | |
function | setFormattingCellsAllowed(value) | |
Represents if the formatting of cells is allowed on a protected worksheet. | ||
function | isFormattingColumnsAllowed() | |
function | setFormattingColumnsAllowed(value) | |
Represents if the formatting of columns is allowed on a protected worksheet | ||
function | isFormattingRowsAllowed() | |
function | setFormattingRowsAllowed(value) | |
Represents if the formatting of rows is allowed on a protected worksheet | ||
function | isInsertingColumnsAllowed() | |
function | setInsertingColumnsAllowed(value) | |
Represents if the insertion of columns is allowed on a protected worksheet | ||
function | isInsertingHyperlinksAllowed() | |
function | setInsertingHyperlinksAllowed(value) | |
Represents if the insertion of hyperlinks is allowed on a protected worksheet | ||
function | isInsertingRowsAllowed() | |
function | setInsertingRowsAllowed(value) | |
Represents if the insertion of rows is allowed on a protected worksheet | ||
function | isProtectedWithPassword() | |
Indicates whether the worksheets is protected with password. | ||
function | isSelectingLockedCellsAllowed() | |
function | setSelectingLockedCellsAllowed(value) | |
Represents if the user is allowed to select locked cells on a protected worksheet. | ||
function | isSelectingUnlockedCellsAllowed() | |
function | setSelectingUnlockedCellsAllowed(value) | |
Represents if the user is allowed to select unlocked cells on a protected worksheet. | ||
function | isSortingAllowed() | |
function | setSortingAllowed(value) | |
Represents if the sorting option is allowed on a protected worksheet. | ||
function | isUsingPivotTablesAllowed() | |
function | setUsingPivotTablesAllowed(value) | |
Represents if the user is allowed to manipulate pivot tables on a protected worksheet. | ||
function | getPassword() | |
function | setPassword(value) | |
Represents the password to protect the worksheet. |
Method Summary | ||
---|---|---|
function | copy(source) | |
Copy protection info. | ||
function | getPasswordHash() | |
Gets the hash of current password. | ||
function | verifyPassword(password) | |
Verifies password. |
Property Getters/Setters Detail |
---|
getAllowDeletingColumn/setAllowDeletingColumn : boolean | |
function getAllowDeletingColumn() / function setAllowDeletingColumn(value) |
isDeletingColumnsAllowed/setDeletingColumnsAllowed : boolean | |
function isDeletingColumnsAllowed() / function setDeletingColumnsAllowed(value) |
getAllowDeletingRow/setAllowDeletingRow : boolean | |
function getAllowDeletingRow() / function setAllowDeletingRow(value) |
isDeletingRowsAllowed/setDeletingRowsAllowed : boolean | |
function isDeletingRowsAllowed() / function setDeletingRowsAllowed(value) |
getAllowFiltering/setAllowFiltering : boolean | |
function getAllowFiltering() / function setAllowFiltering(value) |
isFilteringAllowed/setFilteringAllowed : boolean | |
function isFilteringAllowed() / function setFilteringAllowed(value) |
getAllowFormattingCell/setAllowFormattingCell : boolean | |
function getAllowFormattingCell() / function setAllowFormattingCell(value) |
isFormattingCellsAllowed/setFormattingCellsAllowed : boolean | |
function isFormattingCellsAllowed() / function setFormattingCellsAllowed(value) |
getAllowFormattingColumn/setAllowFormattingColumn : boolean | |
function getAllowFormattingColumn() / function setAllowFormattingColumn(value) |
isFormattingColumnsAllowed/setFormattingColumnsAllowed : boolean | |
function isFormattingColumnsAllowed() / function setFormattingColumnsAllowed(value) |
getAllowFormattingRow/setAllowFormattingRow : boolean | |
function getAllowFormattingRow() / function setAllowFormattingRow(value) |
isFormattingRowsAllowed/setFormattingRowsAllowed : boolean | |
function isFormattingRowsAllowed() / function setFormattingRowsAllowed(value) |
getAllowInsertingColumn/setAllowInsertingColumn : boolean | |
function getAllowInsertingColumn() / function setAllowInsertingColumn(value) |
isInsertingColumnsAllowed/setInsertingColumnsAllowed : boolean | |
function isInsertingColumnsAllowed() / function setInsertingColumnsAllowed(value) |
getAllowInsertingHyperlink/setAllowInsertingHyperlink : boolean | |
function getAllowInsertingHyperlink() / function setAllowInsertingHyperlink(value) |
isInsertingHyperlinksAllowed/setInsertingHyperlinksAllowed : boolean | |
function isInsertingHyperlinksAllowed() / function setInsertingHyperlinksAllowed(value) |
getAllowInsertingRow/setAllowInsertingRow : boolean | |
function getAllowInsertingRow() / function setAllowInsertingRow(value) |
isInsertingRowsAllowed/setInsertingRowsAllowed : boolean | |
function isInsertingRowsAllowed() / function setInsertingRowsAllowed(value) |
getAllowSorting/setAllowSorting : boolean | |
function getAllowSorting() / function setAllowSorting(value) |
isSortingAllowed/setSortingAllowed : boolean | |
function isSortingAllowed() / function setSortingAllowed(value) |
getAllowUsingPivotTable/setAllowUsingPivotTable : boolean | |
function getAllowUsingPivotTable() / function setAllowUsingPivotTable(value) |
isUsingPivotTablesAllowed/setUsingPivotTablesAllowed : boolean | |
function isUsingPivotTablesAllowed() / function setUsingPivotTablesAllowed(value) |
getAllowEditingContent/setAllowEditingContent : boolean | |
function getAllowEditingContent() / function setAllowEditingContent(value) |
isEditingContentsAllowed/setEditingContentsAllowed : boolean | |
function isEditingContentsAllowed() / function setEditingContentsAllowed(value) |
getAllowEditingObject/setAllowEditingObject : boolean | |
function getAllowEditingObject() / function setAllowEditingObject(value) |
isEditingObjectsAllowed/setEditingObjectsAllowed : boolean | |
function isEditingObjectsAllowed() / function setEditingObjectsAllowed(value) |
getAllowEditingScenario/setAllowEditingScenario : boolean | |
function getAllowEditingScenario() / function setAllowEditingScenario(value) |
isEditingScenariosAllowed/setEditingScenariosAllowed : boolean | |
function isEditingScenariosAllowed() / function setEditingScenariosAllowed(value) |
getPassword/setPassword : String | |
function getPassword() / function setPassword(value) |
isProtectedWithPassword : boolean | |
function isProtectedWithPassword() |
getAllowSelectingLockedCell/setAllowSelectingLockedCell : boolean | |
function getAllowSelectingLockedCell() / function setAllowSelectingLockedCell(value) |
isSelectingLockedCellsAllowed/setSelectingLockedCellsAllowed : boolean | |
function isSelectingLockedCellsAllowed() / function setSelectingLockedCellsAllowed(value) |
getAllowSelectingUnlockedCell/setAllowSelectingUnlockedCell : boolean | |
function getAllowSelectingUnlockedCell() / function setAllowSelectingUnlockedCell(value) |
isSelectingUnlockedCellsAllowed/setSelectingUnlockedCellsAllowed : boolean | |
function isSelectingUnlockedCellsAllowed() / function setSelectingUnlockedCellsAllowed(value) |
Method Detail |
---|
copy | |
function copy(source) |
source: Protection
- getPasswordHash | |
function getPasswordHash() |
verifyPassword | |
function verifyPassword(password) |
password: String
- The password.