12.3.11 Pivot Table Part
Content Type:
application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml
Root Namespace:
http://purl.oclc.org/ooxml/spreadsheetml/main
Source Relationship:
http://purl.oclc.org/ooxml/officeDocument/relationships/pivotTable
An instance of this part type contains a pivot table definition.
A package shall contain exactly one Pivot Table part per pivot table, and each such part shall be the target of an implicit relationship in the relationship part for the Worksheet part (12.3.24) that corresponds to the worksheet containing the pivot table.
[Example: The following Worksheet part-relationship item contains a relationship to two Pivot Table parts, which are stored in the ZIP items ../pivotTables/pivotTableN.xml:
<Relationships xmlns="…">
<Relationship Id="rId1"
Type="http://…/pivotTable" Target="../pivotTables/pivotTable1.xml"/>
<Relationship Id="rId2"
Type="http://…/pivotTable" Target="../pivotTables/pivotTable2.xml"/>
</Relationships>end example]
The root element for a part of this content type shall be pivotTableDefinition.
[Example: pivotTable1.xml contains the following:
<pivotTableDefinition … cache="4" applyNumberFormats="0" applyBorderFormats="0"
applyFontFormats="0" applyPatternFormats="0" applyAlignmentFormats="0"
applyWidthHeightFormats="1" dataCaption="Data" updatedVersion="3"
minRefreshableVersion="3" useAutoFormatting="1" itemPrintTitles="1"
createdVersion="3" indent="0" outline="1" outlineData="1">
<location ref="H4:H5" firstHeaderRow="1" firstDataRow="1" firstDataCol="0"/>
<pivotFields count="1">
<pivotField dataField="1" numFmtId="0" outline="1"
subtotalTop="1" showAll="0" measureFilter="0" sortType="manual"/>
</pivotFields>
<rowItems count="1">
<i t="data"/>
</rowItems>
<colItems count="1">
<i t="data"/>
</colItems>
<dataFields count="1">
<dataField name="Sum of 1000" fld="0" subtotal="average"
baseField="0" baseItem="0" numFmtId="0"/>
</dataFields>
<tableStyle name="TableStyle2" showRowHeaders="1" showColHeaders="1"
showRowStripes="1" showColStripes="1"/>
</pivotTableDefinition>end example]
A Pivot Table 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 part is permitted to have implicit relationships to the following parts defined by ISO/IEC 29500:
- Pivot Table Cache Definition (12.3.12).
A Pivot Table part shall not have any implicit or explicit relationships to other parts defined by ISO/IEC 29500.