[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
protection (Protection Properties)
Contains protection properties associated with the cell. Each cell has protection properties that can be set. The cell protection properties do not take effect unless the sheet has been protected.
|
Parent Elements |
|
dxf (§3.8.14); ndxf (§3.11.1.4); odxf (§3.11.1.6); xf (§3.8.45) |
|
Attributes |
Description |
|
hidden (Hidden Cell) |
A boolean value indicating if the cell is hidden. When the cell is hidden and the sheet on which the cell resides is protected, then the cell value will be displayed in the cell grid location, but the contents of the cell will not be displayed in the formula bar. This is true for all types of cell content, including formula, text, or numbers.
Therefore the cell A4 may contain a formula "=SUM(A1:A3)", but if the cell protection property of A4 is marked as hidden, and the sheet is protected, then the cell should display the calculated result (for example, "6"), but will not display the formula used to calculate the result.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
locked (Cell Locked) |
A boolean value indicating if the cell is locked. When cells are marked as "locked" and the sheet is protected, then the options specified in the Sheet Part's sheetProtection element (§3.3.1.81) are prohibited for these cells.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_CellProtection">
<attribute name="locked" type="xsd:boolean" use="optional"/>
<attribute name="hidden" type="xsd:boolean" use="optional"/>
</complexType>