DocumentID: ECMA-376/Part1/12.3.1 Title: ECMA-376, Part1: 12.3.1 Calculation Chain Part Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006 Warning: Coverted to HTML format by a script known to have bugs
|
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: 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 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.