[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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>