12.3.21 Table Definition Part

Content Type:

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

Root Namespace:

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

Source Relationship:

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

An instance of this part type contains a description of a single table and its autofilter information. (The data for the table is stored in the corresponding Worksheet part.)

A package shall contain one Table Definition part per table, and each such part shall be the target of an implicit relationship from the Worksheet (12.3.24) part that corresponds to the worksheet containing that table.

[Example: The following Worksheet part-relationship item contains relationships to two Table Definition parts, which are stored in the ZIP items ../tables/tableN.xml:

<Relationships xmlns="…">
  <Relationship Id="rId2"
    Type="http://…/table" Target="../tables/table1.xml"/>
  <Relationship Id="rId3"
    Type="http://…/table" Target="../tables/table2.xml"/>
</Relationships>

end example]

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

[Example: table2.xml describes a table that spans a 2-column range of cells, F2:G19:

<table xmlns:af="…" … id="2" name="Table2" displayName="Table2" ref="F2:G19"
  totalsRowShown="0" headerRowDxfId="7">
  <autoFilter ref="F2:G19"/>
  <tableColumns count="2">
    <tableColumn id="1" name="Salesman" dataDxfId="9" totalsRowDxfId="6"/>
    <tableColumn id="2" name="Units" dataDxfId="8" totalsRowDxfId="5"/>
  </tableColumns>
  <tableStyle name="TableStyle2" showFirstColumn="0" showLastColumn="0"
    showRowStripes="1" showColumnStripes="1"/>
</table>

When the filter “Salesman equal to Smith” is applied, the autoFilter element in table2.xml is extended, as follows:

<autoFilter ref="F2:G19">
  <af:filterColumn colId="0">
    <af:filters>
      <af:filter val="Smith"/>
    </af:filters>
  </af:filterColumn>
</autoFilter>

end example]

A Table 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 Table Definition part is permitted to explicit relationships to the following parts defined by ISO/IEC 29500:

• Query Table (12.3.14)

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