Interface: ProtectInfo

Sheet protection settings controlling what users can do on a protected sheet

Properties

password

optional

password: string

Password hash for sheet protection

selectLockedCells

optional

selectLockedCells: boolean

If true, users can select locked cells

selectUnlockedCells

optional

selectUnlockedCells: boolean

If true, users can select unlocked cells

formatCells

optional

formatCells: boolean

If true, users can format cells

formatColumns

optional

formatColumns: boolean

If true, users can format columns

formatRows

optional

formatRows: boolean

If true, users can format rows

insertColumns

optional

insertColumns: boolean

If true, users can insert columns

insertRows

optional

insertRows: boolean

If true, users can insert rows

insertHyperlinks

optional

insertHyperlinks: boolean

If true, users can insert hyperlinks

deleteColumns

optional

deleteColumns: boolean

If true, users can delete columns

deleteRows

optional

deleteRows: boolean

If true, users can delete rows

sort

optional

sort: boolean

If true, users can sort

autoFilter

optional

autoFilter: boolean

If true, users can use autofilter

pivotTables

optional

pivotTables: boolean

If true, users can use pivot tables

objects

optional

objects: boolean

If true, users can edit objects (charts, shapes, etc.)

scenarios

optional

scenarios: boolean

If true, users can edit scenarios

Source

src/types.ts

← Properties | Range →