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>