Skip to content

@sheetkit/node / JsSheetProtectionConfig

Interface: JsSheetProtectionConfig ​

Defined in: packages/sheetkit/binding.d.ts:1096

Configuration for sheet protection.

Properties ​

autoFilter? ​

optional autoFilter?: boolean

Defined in: packages/sheetkit/binding.d.ts:1122

Allow using auto-filter.


deleteColumns? ​

optional deleteColumns?: boolean

Defined in: packages/sheetkit/binding.d.ts:1116

Allow deleting columns.


deleteRows? ​

optional deleteRows?: boolean

Defined in: packages/sheetkit/binding.d.ts:1118

Allow deleting rows.


formatCells? ​

optional formatCells?: boolean

Defined in: packages/sheetkit/binding.d.ts:1104

Allow formatting cells.


formatColumns? ​

optional formatColumns?: boolean

Defined in: packages/sheetkit/binding.d.ts:1106

Allow formatting columns.


formatRows? ​

optional formatRows?: boolean

Defined in: packages/sheetkit/binding.d.ts:1108

Allow formatting rows.


insertColumns? ​

optional insertColumns?: boolean

Defined in: packages/sheetkit/binding.d.ts:1110

Allow inserting columns.


optional insertHyperlinks?: boolean

Defined in: packages/sheetkit/binding.d.ts:1114

Allow inserting hyperlinks.


insertRows? ​

optional insertRows?: boolean

Defined in: packages/sheetkit/binding.d.ts:1112

Allow inserting rows.


password? ​

optional password?: string

Defined in: packages/sheetkit/binding.d.ts:1098

Optional password (hashed with legacy Excel algorithm).


pivotTables? ​

optional pivotTables?: boolean

Defined in: packages/sheetkit/binding.d.ts:1124

Allow using pivot tables.


selectLockedCells? ​

optional selectLockedCells?: boolean

Defined in: packages/sheetkit/binding.d.ts:1100

Allow selecting locked cells.


selectUnlockedCells? ​

optional selectUnlockedCells?: boolean

Defined in: packages/sheetkit/binding.d.ts:1102

Allow selecting unlocked cells.


sort? ​

optional sort?: boolean

Defined in: packages/sheetkit/binding.d.ts:1120

Allow sorting.

Released under the MIT / Apache-2.0 License.