Skip to content

API reference / Common / Engine types / GridCellProtection

Interface: GridCellProtection ​

A cell's protection — styleSheet/cellXfs/xf/protection (CT_CellProtection, §18.8.33), and the same under styleSheet/cellStyleXfs/xf and styleSheet/dxfs/dxf. It takes effect only while the sheet is protected, and changes nothing the grid draws. The paths below are given under styleSheet/cellXfs/xf/protection.

Properties ​

PropertyDescription
locked?
boolean
styleSheet/cellXfs/xf/protection/@locked — the cell can't be edited. Office takes true when absent (MS-OI29500 §2.1.714).
hidden?
boolean
styleSheet/cellXfs/xf/protection/@hidden — the formula bar hides the cell's contents; the grid still shows its value. Office takes false when absent (MS-OI29500 §2.1.714).