[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This collection describes each input cell for the scenario.
Parent Elements |
scenario (§3.3.1.73) |
Attributes |
Description |
deleted (Deleted) |
Input cell was deleted. This input cell shall be present in the file format, but shall not be presented to the user as part of the scenario inputs, nor run as part of the scenario.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
numFmtId (Number Format Id) |
This number format Id is used only when displaying the scenario manager input UI, and is used to properly format for display the cached input values (see val attribute) for the scenario.
The possible values for this attribute are defined by the ST_NumFmtId simple type (§3.18.49). |
r (Reference) |
Cell reference indicating the input cell address.
The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8). |
undone (Undone) |
Cell's deletion was undone. When true the r (reference) value shall not adjust in response to the cell moving due to row / column insert or delete,or cell move.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
val (Value) |
Value that should be used for the cell when this scenario is run.
Note: val does not need a corresponding data type, the value is put into the cell when the scenario is run.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_InputCells">
<attribute name="r" type="ST_CellRef" use="required"/>
<attribute name="deleted" type="xsd:boolean" use="optional" default="false"/>
<attribute name="undone" type="xsd:boolean" use="optional" default="false"/>
<attribute name="val" type="ST_Xstring" use="required"/>
<attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
</complexType>