public class SheetProtection extends Object
Using SheetProtection.Builder
you can construct a SheetProtection object.
Modifier and Type | Class and Description |
---|---|
static class |
SheetProtection.Builder
Builder is used to build instances of SheetProtection from values configured by the setters
|
Modifier and Type | Method and Description |
---|---|
String |
getPassword()
Returns the password.
|
boolean |
isAutoFilterAllowed()
Returns whether to allow user to set filters on the protected sheet.
|
boolean |
isDeleteColumnsAllowed()
Returns whether to allow user to delete columns on the protected sheet.
|
boolean |
isDeleteRowsAllowed()
Returns whether to allow user to delete rows on the protected sheet.
|
boolean |
isFormatCellsAllowed()
Returns whether to allow user to format any cell on the protected sheet.
|
boolean |
isFormatColumnsAllowed()
Returns whether to allow user to format any columns on the protected sheet.
|
boolean |
isFormatRowsAllowed()
Returns whether to allow user to format any rows on the protected sheet.
|
boolean |
isInsertColumnsAllowed()
Returns whether to allow user to insert columns on the protected sheet.
|
boolean |
isInsertHyperlinksAllowed()
Returns whether to allow user to insert hyperlinks on the protected sheet.
|
boolean |
isInsertRowsAllowed()
Returns whether to allow user to insert rows on the protected sheet.
|
boolean |
isObjectsEditable()
Returns whether to protect objects.
|
boolean |
isPivotTablesAllowed()
Returns whether to allow user to use pivot table reports on the protected sheet.
|
boolean |
isScenariosEditable()
Returns whether to protect scenarios.
|
boolean |
isSelectLockedCellsAllowed()
Returns whether to allow select locked cells.
|
boolean |
isSelectUnlockedCellsAllowed()
Returns whether to allow select unlocked cells.
|
boolean |
isSortAllowed()
Returns whether to allow user to sort on the protected sheet.
|
public String getPassword()
public boolean isObjectsEditable()
Default to true
public boolean isScenariosEditable()
Default to true
public boolean isFormatCellsAllowed()
Default to false
public boolean isFormatColumnsAllowed()
Default to false
public boolean isFormatRowsAllowed()
Default to false
public boolean isInsertColumnsAllowed()
Default to false
public boolean isInsertRowsAllowed()
Default to false
public boolean isInsertHyperlinksAllowed()
Default to false
public boolean isDeleteColumnsAllowed()
Default to false
public boolean isDeleteRowsAllowed()
Default to false
public boolean isSortAllowed()
Default to false
public boolean isAutoFilterAllowed()
Default to false
public boolean isPivotTablesAllowed()
Default to false
public boolean isSelectLockedCellsAllowed()
Default to false
public boolean isSelectUnlockedCellsAllowed()
Default to false
Copyright © 2020. All rights reserved.