12.3.1 Calculation Chain Part
Content Type:
Root Namespace:
Source Relationship:
Root Element
Ref.
application/vnd.openxmlformats-officedocument.spreadsheetml.calcChain+xml
http://purl.oclc.org/ooxml/spreadsheetml/main
http://purl.oclc.org/ooxml/officeDocument/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: The following Workbook part-relationship item contains a relationship to the Calculation Chain part, which is stored in the ZIP item calcChain.xml:
<Relationships xmlns="…">
<Relationship Id="rId7"
Type="http://…/calcChain" Target="calcChain.xml"/>
</Relationships>end example]
The root element for a part of this content type shall be calcChain.
[Example: Cells D8, E8, and F8 each contain a value that is the result of calculations that shall be performed in the order E8, D8, F8:
<calcChain xmlns="…">
<c r="E8" i="1"/>
<c r="D8"/>
<c r="F8" s="1"/>
</calcChain>end example]
A Calculation Chain part shall be located within the package containing the relationships part (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 ISO/IEC 29500.