12.3.12 Pivot Table Cache Definition Part

Content Type:

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

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/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"
  refreshedDateIso="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 relationships part (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 ISO/IEC 29500:

• Pivot Table Cache Records (12.3.13).

A Pivot Table Cache Definition part shall not have any implicit or explicit relationships to other parts defined by ISO/IEC 29500.