@sheetkit/node / JsSheetProtectionConfig

Interface: JsSheetProtectionConfig

Defined in: binding.d.ts:976

Configuration for sheet protection.

Properties

autoFilter?

optional autoFilter: boolean

Defined in: binding.d.ts:1002

Allow using auto-filter.

---

deleteColumns?

optional deleteColumns: boolean

Defined in: binding.d.ts:996

Allow deleting columns.

---

deleteRows?

optional deleteRows: boolean

Defined in: binding.d.ts:998

Allow deleting rows.

---

formatCells?

optional formatCells: boolean

Defined in: binding.d.ts:984

Allow formatting cells.

---

formatColumns?

optional formatColumns: boolean

Defined in: binding.d.ts:986

Allow formatting columns.

---

formatRows?

optional formatRows: boolean

Defined in: binding.d.ts:988

Allow formatting rows.

---

insertColumns?

optional insertColumns: boolean

Defined in: binding.d.ts:990

Allow inserting columns.

---

insertHyperlinks?

optional insertHyperlinks: boolean

Defined in: binding.d.ts:994

Allow inserting hyperlinks.

---

insertRows?

optional insertRows: boolean

Defined in: binding.d.ts:992

Allow inserting rows.

---

password?

optional password: string

Defined in: binding.d.ts:978

Optional password (hashed with legacy Excel algorithm).

---

pivotTables?

optional pivotTables: boolean

Defined in: binding.d.ts:1004

Allow using pivot tables.

---

selectLockedCells?

optional selectLockedCells: boolean

Defined in: binding.d.ts:980

Allow selecting locked cells.

---

selectUnlockedCells?

optional selectUnlockedCells: boolean

Defined in: binding.d.ts:982

Allow selecting unlocked cells.

---

sort?

optional sort: boolean

Defined in: binding.d.ts:1000

Allow sorting.