Share via


CalculationCell Class

Cell.When the object is serialized out as xml, its qualified name is x:c.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.CalculationCell

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Class CalculationCell _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As CalculationCell
public class CalculationCell : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.6.1 c (Cell)

This element represents a single cell, which shall contain a formula, in the calc chain. Cells are calculated in the same order as the c elements appear in the Calculation Chain part.

Parent Elements

calcChain (§18.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 formula, false otherwise. If there is a conflict between this attribute and the t attribute of the f element (§18.3.1.40), the t attribute takes precedence.

The possible values for this attribute are defined by the W3C 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 W3C 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, shall be completed - and the cells have new values - before the calc chain can continue. In other words, this dependency level might depend on levels that came before it, and any later dependency levels might 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 W3C 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 (§18.18.7).

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 W3C 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 W3C XML Schema boolean datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_CalcCell) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

CalculationCell Members

DocumentFormat.OpenXml.Spreadsheet Namespace