<c>
(Cell)
This element represents a single cell, which shall contain a formula, in the calc chain. Cell's are calculated in the same order as c
attribute is listed in the xml, starting from the top.
Parent Elements |
---|
|
Attributes |
Description |
---|---|
|
A Boolean flag indicating whether the cell's formula is an array formula. True if this cell's formula is an array entered formula, false otherwise. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
A sheet Id of a sheet the cell belongs to. If this is omitted, it is assumed to be the same as the The possible values for this attribute are defined by the XML Schema int datatype. |
|
A Boolean flag indicating that the cell's formula starts a new dependency level. True if the formula starts a new dependency level, false otherwise. Starting a new dependency level means that all concurrent calculations, and child calculations, must be completed - and the cells have new values - before the calc chain can continue. In other words, this dependency level may depend on levels that came before it, and any later dependency levels may depend on this level; but not later dependency levels can have any calculations started until this dependency level completes. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
An A-1 style reference to a cell. The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8). |
|
A Boolean flag indicating whether the cell's formula is on a child chain. True if this cell is part of a child chain, false otherwise. If this is omitted, it is assumed to be the same as the A child chain is a list of calculations that occur which depend on the parent to the chain. There shall not be cross dependencies between child chains. Child chains are not the same as dependency levels - a child chain and its parent are all on the same dependency level. Child chains are series of calculations that can be independently farmed out to other threads or processors. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
A Boolean flag indicating whether the cell's formula starts a new thread. True if the cell's formula starts a new thread, false otherwise. 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_CalcCell">
<attribute name="r" type="ST_CellRef" use="required"/>
<attribute name="i" type="xsd:int" use="optional" default="0"/>
<attribute name="s" type="xsd:boolean" use="optional" default="false"/>
<attribute name="l" type="xsd:boolean" use="optional" default="false"/>
<attribute name="t" type="xsd:boolean" use="optional" default="false"/>
<attribute name="a" type="xsd:boolean" use="optional" default="false"/>
</complexType>