Parent Elements

formats (§3.10.1.36)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

pivotArea (Pivot Area)

§3.3.1.66

Attributes

Description

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).