CellProtectProperties
Set cell lock or cell hiding.
Signature:
export interface CellProtectPropertiesRemarks
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
| Property | Type | Description |
|---|---|---|
| hidden | string | Hide formula |
| locked | string | lock |
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.