Calculation Chain Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.calcChain+xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/calcChain

An instance of this part type contains an ordered set of references to all cells in all worksheets in the workbook whose value is calculated from any formula. The ordering allows inter-related cell formulas to be calculated in the correct order when a worksheet is loaded for use.

A package shall contain no more than one Calculation Chain part. If it exists, that part shall be the target of an implicit relationship from the Workbook part (§12.3.23).

example:

<Relationships xmlns="…">
  <Relationship Id="rId7" 
    Type="http://…/calcChain" Target="calcChain.xml"/>
</Relationships>

The root element for a part of this content type shall be< calcChain>.

example:

<calcChain xmlns="…">
  <c r="E8" i="1"/>
  <c r="D8"/>
  <c r="F8" s="1"/>
</calcChain>

A Calculation Chain part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

A Calculation Chain part shall not have implicit or explicit relationships to any part defined by this Standard.