DocumentID: ECMA-376/Part1/12.3.12 Title: ECMA-376, Part1: 12.3.12 Pivot Table Cache Definition 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.pivotCacheDefinition+xml |
|---|---|
|
Root Namespace: |
http://schemas.openxmlformats.org/spreadsheetml/2006/main |
|
Source Relationship: |
http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition |
An instance of this part type contains a cache definition for a pivot table.
A package shall contain exactly one Pivot Table Cache Definition part per pivot table, and each such part shall be the target of an implicit relationship from a Pivot Table (§12.3.11) part as well as an explicit relationship from a Workbook (§12.3.23) part.
[Example: The following Pivot Table part-relationship item contains a relationship to the Pivot Table Cache Definition part, which is stored in the ZIP item ../pivotCache/pivotCacheDefinition2.xml:
<Relationships xmlns="...">
<Relationship Id="rId1"
Type=http://.../pivotCacheDefinition
Target="../pivotCache/pivotCacheDefinition2.xml"/>
</Relationships>
end example]
The root element for a part of this content type shall be pivotCacheDefinition.
[Example: pivotCacheDefinition2.xml contains the following:
<pivotCacheDefinition ... r:id="rId1" refreshedBy="John Jones"
refreshedDate="2005-11-18T16:47:49" createdVersion="3"
refreshedVersion="3" recordCount="11">
<cacheSource type="worksheet">
<worksheet range="C4:C15" sheet="Sheet1"/>
</cacheSource>
<cacheFields count="1">
<cacheField name="1000">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" containsInteger="1" minValue="234
maxValue="2543"/>
</cacheField>
</cacheFields>
</pivotCacheDefinition>
end example]
A Pivot Table Cache Definition part shall be located within the package containing the source relationship (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).
A Pivot Table Cache Definition part is permitted to have an explicit relationship to the following part defined by this Standard:
A Pivot Table Cache Definition part shall not have any implicit or explicit relationships to other parts defined by this Standard.