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 |
isAllowDeletingColumns()
Returns whether to allow user to delete columns on the protected sheet.
|
boolean |
isAllowDeletingRows()
Returns whether to allow user to delete rows on the protected sheet.
|
boolean |
isAllowFiltering()
Returns whether to allow user to set filters on the protected sheet.
|
boolean |
isAllowFormattingCells()
Returns whether to allow user to format any cell on the protected sheet.
|
boolean |
isAllowFormattingColumns()
Returns whether to allow user to format any columns on the protected sheet.
|
boolean |
isAllowFormattingRows()
Returns whether to allow user to format any rows on the protected sheet.
|
boolean |
isAllowInsertingColumns()
Returns whether to allow user to insert columns on the protected sheet.
|
boolean |
isAllowInsertingHyperlinks()
Returns whether to allow user to insert hyperlinks on the protected sheet.
|
boolean |
isAllowInsertingRows()
Returns whether to allow user to insert rows on the protected sheet.
|
boolean |
isAllowSelectLockedCells()
Returns whether to allow select locked cells.
|
boolean |
isAllowSelectUnlockedCells()
Returns whether to allow select unlocked cells.
|
boolean |
isAllowSorting()
Returns whether to allow user to sort on the protected sheet.
|
boolean |
isAllowUsingPivotTables()
Returns whether to allow user to use pivot table reports on the protected sheet.
|
boolean |
isDrawingObjects()
Returns whether to protect objects.
|
boolean |
isScenarios()
Returns whether to protect scenarios.
|
boolean |
isUserInterfaceOnly()
Returns whether to forbid user to modify this the through UI.
|
public String getPassword()
public boolean isDrawingObjects()
Default to true
public boolean isScenarios()
Default to true
public boolean isUserInterfaceOnly()
Default to false
public boolean isAllowFormattingCells()
Default to false
public boolean isAllowFormattingColumns()
Default to false
public boolean isAllowFormattingRows()
Default to false
public boolean isAllowInsertingColumns()
Default to false
public boolean isAllowInsertingRows()
Default to false
public boolean isAllowInsertingHyperlinks()
Default to false
public boolean isAllowDeletingColumns()
Default to false
public boolean isAllowDeletingRows()
Default to false
public boolean isAllowSorting()
Default to false
public boolean isAllowFiltering()
Default to false
public boolean isAllowUsingPivotTables()
Default to false
public boolean isAllowSelectLockedCells()
Default to false
public boolean isAllowSelectUnlockedCells()
Default to false
Copyright © 2018. All rights reserved.