static SheetProtection.Builder |
SheetProtection.Builder.create() |
Creates the builder instance.
|
SheetProtection.Builder |
SheetProtection.Builder.withAutoFilterAllowed(boolean autoFilterAllowed) |
Sets true to allow user to set filters on the protected sheet
|
SheetProtection.Builder |
SheetProtection.Builder.withDeleteColumnsAllowed(boolean deleteColumnsAllowed) |
Sets true to allow user to delete columns on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withDeleteRowsAllowed(boolean deleteRowsAllowed) |
Sets true to allow user to delete rows on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withFormatCellsAllowed(boolean formatCellsAllowed) |
Sets true to allow user to format any cell on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withFormatColumnsAllowed(boolean formatColumnsAllowed) |
Sets true to allow user to format any columns on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withFormatRowsAllowed(boolean formatRowsAllowed) |
Sets true to allow user to format any rows on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withInsertColumnsAllowed(boolean insertColumnsAllowed) |
Sets true to allow user to insert columns on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withInsertHyperlinksAllowed(boolean insertHyperlinksAllowed) |
Sets true to allow user to insert hyperlinks on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withInsertRowsAllowed(boolean insertRowsAllowed) |
Sets true to allow user to insert rows on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withObjectsEditable(boolean objectsEditable) |
Sets the objectsEditable to true to protect objects.
|
SheetProtection.Builder |
SheetProtection.Builder.withPassword(String password) |
Sets the case-sensitive password for the sheet; null or empty string
means protect the sheet without password.
|
SheetProtection.Builder |
SheetProtection.Builder.withPivotTablesAllowed(boolean pivotTablesAllowed) |
Sets true to allow user to use pivot table reports on the protected sheet.
|
SheetProtection.Builder |
SheetProtection.Builder.withScenariosEditable(boolean scenarios) |
Sets true to protect scenarios.
|
SheetProtection.Builder |
SheetProtection.Builder.withSelectLockedCellsAllowed(boolean selectLockedCellsAllowed) |
Sets true to allow select locked cells.
|
SheetProtection.Builder |
SheetProtection.Builder.withSelectUnlockedCellsAllowed(boolean selectUnlockedCellsAllowed) |
Sets true to allow select unlocked cells
|
SheetProtection.Builder |
SheetProtection.Builder.withSortAllowed(boolean sortAllowed) |
Sets true to allow user to sort on the protected sheet.
|