Uses of Class
io.keikai.api.SheetProtection.Builder
Packages that use SheetProtection.Builder
-
Uses of SheetProtection.Builder in io.keikai.api
Methods in io.keikai.api that return SheetProtection.BuilderModifier and TypeMethodDescriptionstatic SheetProtection.BuilderSheetProtection.Builder.create()Creates the builder instance.SheetProtection.Builder.withAutoFilterAllowed(boolean autoFilterAllowed) Sets true to allow user to set filters on the protected sheetSheetProtection.Builder.withDeleteColumnsAllowed(boolean deleteColumnsAllowed) Sets true to allow user to delete columns on the protected sheet.SheetProtection.Builder.withDeleteRowsAllowed(boolean deleteRowsAllowed) Sets true to allow user to delete rows on the protected sheet.SheetProtection.Builder.withFormatCellsAllowed(boolean formatCellsAllowed) Sets true to allow user to format any cell on the protected sheet.SheetProtection.Builder.withFormatColumnsAllowed(boolean formatColumnsAllowed) Sets true to allow user to format any columns on the protected sheet.SheetProtection.Builder.withFormatRowsAllowed(boolean formatRowsAllowed) Sets true to allow user to format any rows on the protected sheet.SheetProtection.Builder.withInsertColumnsAllowed(boolean insertColumnsAllowed) Sets true to allow user to insert columns on the protected sheet.SheetProtection.Builder.withInsertHyperlinksAllowed(boolean insertHyperlinksAllowed) Sets true to allow user to insert hyperlinks on the protected sheet.SheetProtection.Builder.withInsertRowsAllowed(boolean insertRowsAllowed) Sets true to allow user to insert rows on the protected sheet.SheetProtection.Builder.withObjectsEditable(boolean objectsEditable) Sets the objectsEditable to true to protect objects.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.withPivotTablesAllowed(boolean pivotTablesAllowed) Sets true to allow user to use pivot table reports on the protected sheet.SheetProtection.Builder.withScenariosEditable(boolean scenarios) Sets true to protect scenarios.SheetProtection.Builder.withSelectLockedCellsAllowed(boolean selectLockedCellsAllowed) Sets true to allow select locked cells.SheetProtection.Builder.withSelectUnlockedCellsAllowed(boolean selectUnlockedCellsAllowed) Sets true to allow select unlocked cellsSheetProtection.Builder.withSortAllowed(boolean sortAllowed) Sets true to allow user to sort on the protected sheet.