Package io.keikai.api
Class SheetProtection
- java.lang.Object
-
- io.keikai.api.SheetProtection
-
public class SheetProtection extends Object
SheetProtection values config.Using
SheetProtection.Builderyou can construct a SheetProtection object.- Since:
- 5.0.0
- Author:
- jumperchen
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static classSheetProtection.BuilderBuilder is used to build instances of SheetProtection from values configured by the setters
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description StringgetPassword()Returns the password.booleanisAutoFilterAllowed()Returns whether to allow user to set filters on the protected sheet.booleanisDeleteColumnsAllowed()Returns whether to allow user to delete columns on the protected sheet.booleanisDeleteRowsAllowed()Returns whether to allow user to delete rows on the protected sheet.booleanisFormatCellsAllowed()Returns whether to allow user to format any cell on the protected sheet.booleanisFormatColumnsAllowed()Returns whether to allow user to format any columns on the protected sheet.booleanisFormatRowsAllowed()Returns whether to allow user to format any rows on the protected sheet.booleanisInsertColumnsAllowed()Returns whether to allow user to insert columns on the protected sheet.booleanisInsertHyperlinksAllowed()Returns whether to allow user to insert hyperlinks on the protected sheet.booleanisInsertRowsAllowed()Returns whether to allow user to insert rows on the protected sheet.booleanisObjectsEditable()Returns whether to protect objects.booleanisPivotTablesAllowed()Returns whether to allow user to use pivot table reports on the protected sheet.booleanisScenariosEditable()Returns whether to protect scenarios.booleanisSelectLockedCellsAllowed()Returns whether to allow select locked cells.booleanisSelectUnlockedCellsAllowed()Returns whether to allow select unlocked cells.booleanisSortAllowed()Returns whether to allow user to sort on the protected sheet.
-
-
-
Method Detail
-
getPassword
public String getPassword()
Returns the password.- Returns:
-
isObjectsEditable
public boolean isObjectsEditable()
Returns whether to protect objects.Default to true
- Returns:
-
isScenariosEditable
public boolean isScenariosEditable()
Returns whether to protect scenarios.Default to true
- Returns:
-
isFormatCellsAllowed
public boolean isFormatCellsAllowed()
Returns whether to allow user to format any cell on the protected sheet.Default to false
- Returns:
-
isFormatColumnsAllowed
public boolean isFormatColumnsAllowed()
Returns whether to allow user to format any columns on the protected sheet.Default to false
- Returns:
-
isFormatRowsAllowed
public boolean isFormatRowsAllowed()
Returns whether to allow user to format any rows on the protected sheet.Default to false
- Returns:
-
isInsertColumnsAllowed
public boolean isInsertColumnsAllowed()
Returns whether to allow user to insert columns on the protected sheet.Default to false
- Returns:
-
isInsertRowsAllowed
public boolean isInsertRowsAllowed()
Returns whether to allow user to insert rows on the protected sheet.Default to false
- Returns:
-
isInsertHyperlinksAllowed
public boolean isInsertHyperlinksAllowed()
Returns whether to allow user to insert hyperlinks on the protected sheet.Default to false
- Returns:
-
isDeleteColumnsAllowed
public boolean isDeleteColumnsAllowed()
Returns whether to allow user to delete columns on the protected sheet.Default to false
- Returns:
-
isDeleteRowsAllowed
public boolean isDeleteRowsAllowed()
Returns whether to allow user to delete rows on the protected sheet.Default to false
- Returns:
-
isSortAllowed
public boolean isSortAllowed()
Returns whether to allow user to sort on the protected sheet.Default to false
- Returns:
-
isAutoFilterAllowed
public boolean isAutoFilterAllowed()
Returns whether to allow user to set filters on the protected sheet.Default to false
- Returns:
-
isPivotTablesAllowed
public boolean isPivotTablesAllowed()
Returns whether to allow user to use pivot table reports on the protected sheet.Default to false
- Returns:
-
isSelectLockedCellsAllowed
public boolean isSelectLockedCellsAllowed()
Returns whether to allow select locked cells.Default to false
- Returns:
-
isSelectUnlockedCellsAllowed
public boolean isSelectUnlockedCellsAllowed()
Returns whether to allow select unlocked cells.Default to false
- Returns:
-
-