DocumentID: ECMA-376/Part1/12.3.11 Title: ECMA-376, Part1: 12.3.11 Pivot Table 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.pivotTable+xml |
|---|---|
|
Root Namespace: |
http://schemas.openxmlformats.org/spreadsheetml/2006/main |
|
Source Relationship: |
http://schemas.openxmlformats.org/officeDocument/2006/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 source relationship (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 this Standard:
A Pivot Table part shall not have any implicit or explicit relationships to other parts defined by this Standard.