12.3.13 Pivot Table Cache Records Part

Content Type:

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

Root Namespace:

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

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/pivotCacheRecords

An instance of this part type contains the cache records for a pivot table.

A package shall contain zero or one Pivot Table Cache Records part per pivot table, and each such part shall be the target of an explicit relationship in the Pivot Table Cache Definition (12.3.12) part for the corresponding pivot table.

[Example: The following Pivot Table Cache Definition part-relationship item contains a relationship to the Pivot Table Cache Records part, which is stored in the ZIP item pivotCacheRecords2.xml:

<Relationships xmlns="…">
  <Relationship Id="rId1"
    Type="http://…/pivotCacheRecords" Target="pivotCacheRecords2.xml"/>
</Relationships>

end example]

The root element for a part of this content type shall be pivotCacheRecords.

[Example: pivotCacheRecords2.xml contains the following:

<pivotCacheRecords … count="11">
  <r>
    <n v="1234"/>
  </r>
    …
  <r>
    <n v="876"/>
  </r>
</pivotCacheRecords>

end example]

A Pivot Table Cache Records 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 Records part shall not have implicit or explicit relationships to any other part defined by ISO/IEC 29500.