@sheetkit/node / JsSheetProtectionConfig

Interface: JsSheetProtectionConfig

Defined in: binding.d.ts:967

Configuration for sheet protection.

Properties

autoFilter?

optional autoFilter: boolean

Defined in: binding.d.ts:993

Allow using auto-filter.

---

deleteColumns?

optional deleteColumns: boolean

Defined in: binding.d.ts:987

Allow deleting columns.

---

deleteRows?

optional deleteRows: boolean

Defined in: binding.d.ts:989

Allow deleting rows.

---

formatCells?

optional formatCells: boolean

Defined in: binding.d.ts:975

Allow formatting cells.

---

formatColumns?

optional formatColumns: boolean

Defined in: binding.d.ts:977

Allow formatting columns.

---

formatRows?

optional formatRows: boolean

Defined in: binding.d.ts:979

Allow formatting rows.

---

insertColumns?

optional insertColumns: boolean

Defined in: binding.d.ts:981

Allow inserting columns.

---

insertHyperlinks?

optional insertHyperlinks: boolean

Defined in: binding.d.ts:985

Allow inserting hyperlinks.

---

insertRows?

optional insertRows: boolean

Defined in: binding.d.ts:983

Allow inserting rows.

---

password?

optional password: string

Defined in: binding.d.ts:969

Optional password (hashed with legacy Excel algorithm).

---

pivotTables?

optional pivotTables: boolean

Defined in: binding.d.ts:995

Allow using pivot tables.

---

selectLockedCells?

optional selectLockedCells: boolean

Defined in: binding.d.ts:971

Allow selecting locked cells.

---

selectUnlockedCells?

optional selectUnlockedCells: boolean

Defined in: binding.d.ts:973

Allow selecting unlocked cells.

---

sort?

optional sort: boolean

Defined in: binding.d.ts:991

Allow sorting.