CellProtectProperties

Set cell lock or cell hiding.

Signature:

export interface CellProtectProperties

Remarks

Applies only to the DataCell area and cannot be applied to other areas. Used in DataColumn.cellProtectProps or ColumnStyleObject.cellProtectProps. Sheet protection must be set using GridExportOptions.sheetProtect to be applied.

Properties

Properties Desc

hidden

Hide formula

Type - string

Remarks:

To hide the formula in a cell, set hidden to '1'.

locked

lock

Type - string

Remarks:

The default setting for Excel cells is locked. Set locked to '0' for only columns or cells that can be entered.