<ST_PivotAreaType> (Rule Type)

Indicates the type of rule being used to describe an area or aspect of the PivotTable.

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

<all> (All)

Refers to the whole PivotTable.

<button> (Field Button)

Refers to a field button.

<data> (Data)

Refers to something in the data area.

<none> (None)

Refers to no Pivot area.

<normal> (Normal)

Refers to a header or item.

<origin> (Origin)

Refers to the blank cells at the top-left of the PivotTable (top-right for RTL sheets).

<topRight> (Top Right)

Refers to the blank cells at the top-right of the PivotTable (top-left for RTL sheets).

Referenced By

<pivotArea@type> (§3.3.1.66)

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

<simpleType name="ST_PivotAreaType">
	<restriction base="xsd:string">
	<enumeration value="none"/>
	<enumeration value="normal"/>
	<enumeration value="data"/>
	<enumeration value="all"/>
	<enumeration value="origin"/>
	<enumeration value="button"/>
	<enumeration value="topRight"/>
	</restriction>
</simpleType>