Package | Description |
---|---|
io.keikai.api |
Keikai Spreadsheet API classes.
|
Modifier and Type | Method and Description |
---|---|
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.
|
Copyright © 2020. All rights reserved.