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

Fluent builder; every setter takes true = allowed.

Method Summary

Modifier and Type	Method	Description
SheetProtection.Builder	autoFilter(boolean allowed)
SheetProtection	build()
SheetProtection.Builder	deleteColumns(boolean allowed)
SheetProtection.Builder	deleteRows(boolean allowed)
SheetProtection.Builder	formatCells(boolean allowed)
SheetProtection.Builder	formatColumns(boolean allowed)
SheetProtection.Builder	formatRows(boolean allowed)
SheetProtection.Builder	insertColumns(boolean allowed)
SheetProtection.Builder	insertHyperlinks(boolean allowed)
SheetProtection.Builder	insertRows(boolean allowed)
SheetProtection.Builder	objects(boolean allowed)	Allow editing objects (shapes, charts).
SheetProtection.Builder	pivotTables(boolean allowed)
SheetProtection.Builder	scenarios(boolean allowed)	Allow editing what-if scenarios.
SheetProtection.Builder	selectLockedCells(boolean allowed)
SheetProtection.Builder	selectUnlockedCells(boolean allowed)
SheetProtection.Builder	sort(boolean allowed)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

selectLockedCells

public SheetProtection.Builder selectLockedCells(boolean allowed)

selectUnlockedCells

public SheetProtection.Builder selectUnlockedCells(boolean allowed)

formatCells

public SheetProtection.Builder formatCells(boolean allowed)

formatColumns

public SheetProtection.Builder formatColumns(boolean allowed)

formatRows

public SheetProtection.Builder formatRows(boolean allowed)

insertColumns

public SheetProtection.Builder insertColumns(boolean allowed)

insertRows

public SheetProtection.Builder insertRows(boolean allowed)

insertHyperlinks

public SheetProtection.Builder insertHyperlinks(boolean allowed)

deleteColumns

public SheetProtection.Builder deleteColumns(boolean allowed)

deleteRows

public SheetProtection.Builder deleteRows(boolean allowed)

sort

public SheetProtection.Builder sort(boolean allowed)

autoFilter

public SheetProtection.Builder autoFilter(boolean allowed)

pivotTables

public SheetProtection.Builder pivotTables(boolean allowed)

objects

public SheetProtection.Builder objects(boolean allowed)

Allow editing objects (shapes, charts).

scenarios

public SheetProtection.Builder scenarios(boolean allowed)

Allow editing what-if scenarios.

build

public SheetProtection build()