@sheetkit/node / JsSheetProtectionConfig

Interface: JsSheetProtectionConfig

Defined in: binding.d.ts:891

Configuration for sheet protection.

Properties

autoFilter?

optional autoFilter: boolean

Defined in: binding.d.ts:917

Allow using auto-filter.

---

deleteColumns?

optional deleteColumns: boolean

Defined in: binding.d.ts:911

Allow deleting columns.

---

deleteRows?

optional deleteRows: boolean

Defined in: binding.d.ts:913

Allow deleting rows.

---

formatCells?

optional formatCells: boolean

Defined in: binding.d.ts:899

Allow formatting cells.

---

formatColumns?

optional formatColumns: boolean

Defined in: binding.d.ts:901

Allow formatting columns.

---

formatRows?

optional formatRows: boolean

Defined in: binding.d.ts:903

Allow formatting rows.

---

insertColumns?

optional insertColumns: boolean

Defined in: binding.d.ts:905

Allow inserting columns.

---

insertHyperlinks?

optional insertHyperlinks: boolean

Defined in: binding.d.ts:909

Allow inserting hyperlinks.

---

insertRows?

optional insertRows: boolean

Defined in: binding.d.ts:907

Allow inserting rows.

---

password?

optional password: string

Defined in: binding.d.ts:893

Optional password (hashed with legacy Excel algorithm).

---

pivotTables?

optional pivotTables: boolean

Defined in: binding.d.ts:919

Allow using pivot tables.

---

selectLockedCells?

optional selectLockedCells: boolean

Defined in: binding.d.ts:895

Allow selecting locked cells.

---

selectUnlockedCells?

optional selectUnlockedCells: boolean

Defined in: binding.d.ts:897

Allow selecting unlocked cells.

---

sort?

optional sort: boolean

Defined in: binding.d.ts:915

Allow sorting.