[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

calcChain3.6.2)

 

Attributes

Description

a (Array)

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.

i (Sheet Id)

A sheet Id of a sheet the cell belongs to. If this is omitted, it is assumed to be the same as the i value of the previous cell.

 

The possible values for this attribute are defined by the XML Schema int datatype.

l (New Dependency Level)

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.

r (Cell Reference)

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).

s (Child Chain)

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 s value of the previous cell .

 

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.

t (New Thread)

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>