<ST_FormatAction> (PivotTable Format Types)

This simple type defines the type of formats that can be applied to PivotTables.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<blank> (Blank)

Indicates no format is applied to the PivotTable. This value is used when formatting is cleared from already formatted cells in the PivotTable.

<drill> (Drill Type)

Indicates the PivotTable has drill-through format.

<formatting> (Formatting)

Indicates the PivotTable has formatting.

<formula> (Formula Type)

Indicates the PivotTable has formulas.

Referenced By

<format@action> (§3.10.1.35)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_FormatAction">
	<restriction base="xsd:string">
	<enumeration value="blank"/>
	<enumeration value="formatting"/>
	<enumeration value="drill"/>
	<enumeration value="formula"/>
	</restriction>
</simpleType>