<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 |
---|---|
|
Refers to the whole PivotTable. |
|
Refers to a field button. |
|
Refers to something in the data area. |
|
Refers to no Pivot area. |
|
Refers to a header or item. |
|
Refers to the blank cells at the top-left of the PivotTable (top-right for RTL sheets). |
|
Refers to the blank cells at the top-right of the PivotTable (top-left for RTL sheets). |
Referenced By |
---|
|
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>