[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

format (PivotTable Format)

Represents the format defined in the PivotTable.

Parent Elements



Child Elements


extLst (Future Feature Data Storage Area)


pivotArea (Pivot Area)





action (Format Action)

Specifies the formatting behavior for the area indicated in the pivotArea element. The default value for this attribute is "formatting," which indicates that the specified cells have some formatting applied. The format is specified in the dxfId attribute. If the formatting is cleared from the cells, then the value of this attribute becomes "blank."


The possible values for this attribute are defined by the ST_FormatAction simple type (§3.18.35).

dxfId (Format Id)

Specifies the identifier of the format the application is currently using for the PivotTable. Formatting information is written to the styles part. See the Styles section (§3.8) for more information on formats.


Note: Formatting information provided by cell table and by PivotTable need not agree. If the two formats differ, the cell-level formatting takes precedence. If you change the layout the PivotTable, the PivotTable formatting will then take precedence.


The possible values for this attribute are defined by the ST_DxfId simple type (§3.18.26).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Format">


   <element name="pivotArea" type="CT_PivotArea"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>


   <attribute name="action" type="ST_FormatAction" default="formatting"/>

   <attribute name="dxfId" type="ST_DxfId" use="optional"/>