Package io.keikai.axyra.sheets

Class SheetProtection.Builder

java.lang.Object
io.keikai.axyra.sheets.SheetProtection.Builder
Enclosing class:
SheetProtection
public static final class SheetProtection.Builder extends Object
Builder for SheetProtection; every setter takes true = allowed.

  • Method Details

    • selectLockedCells

      public SheetProtection.Builder selectLockedCells(boolean allowed)
      Allows selecting locked cells (default true).

    • selectUnlockedCells

      public SheetProtection.Builder selectUnlockedCells(boolean allowed)
      Allows selecting unlocked cells (default true).

    • formatCells

      public SheetProtection.Builder formatCells(boolean allowed)
      Allows formatting cells (default false).

    • formatColumns

      public SheetProtection.Builder formatColumns(boolean allowed)
      Allows changing column width and format (default false).

    • formatRows

      public SheetProtection.Builder formatRows(boolean allowed)
      Allows changing row height and format (default false).

    • insertColumns

      public SheetProtection.Builder insertColumns(boolean allowed)
      Allows inserting columns (default false).

    • insertRows

      public SheetProtection.Builder insertRows(boolean allowed)
      Allows inserting rows (default false).

    • insertHyperlinks

      public SheetProtection.Builder insertHyperlinks(boolean allowed)
      Allows inserting hyperlinks (default false).

    • deleteColumns

      public SheetProtection.Builder deleteColumns(boolean allowed)
      Allows deleting columns (default false).

    • deleteRows

      public SheetProtection.Builder deleteRows(boolean allowed)
      Allows deleting rows (default false).

    • sort

      public SheetProtection.Builder sort(boolean allowed)
      Allows sorting (default false).

    • autoFilter

      public SheetProtection.Builder autoFilter(boolean allowed)
      Allows using AutoFilter (default false).

    • pivotTables

      public SheetProtection.Builder pivotTables(boolean allowed)
      Allows using PivotTables (default false).

    • objects

      public SheetProtection.Builder objects(boolean allowed)
      Allows editing objects such as shapes and charts (default false).

    • scenarios

      public SheetProtection.Builder scenarios(boolean allowed)
      Allows editing what-if scenarios (default false).

    • build

      public SheetProtection build()
      Builds the immutable SheetProtection.