2.2.5.5 Sheet Extensibility

Sheet extensibility is a mechanism whereby a web drawing specifies extensions to the rules about sections, rows, cells, and function tokens as defined in this specification. Such extensions are specified in SectionDef_Type, RowDef_Type, CellDef_Type, and FunctionDef_Type descendant elements of the Extensions element of the Extensions XML Part.

The valid N attributes of a Section_Type element are specified in section 2.4.1. However, SectionDef_Type elements can specify additional valid N attributes.

The valid N attributes of a Cell_Type element and the locations where a Cell_Type element with a given N attribute can occur are specified in section 2.4.4. However, CellDef_Type elements can specify additional valid N attributes. Additionally, a CellDef_Type element specifies the valid locations where a CellDef_Type element with a given N attribute can occur, based on the CellDef_Type element’s ancestor SectionDef_Type and RowDef_Type elements. Cells defined through sheet extensibility are used for formula evaluation only.

The valid function tokens are specified in section 2.5.3. However, FunctionDef_Type elements can specify additional valid function tokens. A function token defined through sheet extensibility consumes all argument, and returns a PtgErr parse token with an error code equal to #VALUE!.