[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This simple type defines the possible sort order for 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 |
|
ascending (Ascending) |
Indicates that the PivotTable data is sorted in ascending order. |
|
ascendingAlpha (Ascending Alpha) |
Indicates that the PivotTable data is sorted in alphabetic order with ascending values. |
|
ascendingNatural (Ascending Natural) |
Indicates that the PivotTable data is sorted in natural order with ascending. |
|
descending (Descending) |
Indicates that the PivotTable data is sorted in descending. |
|
descendingAlpha (Alphabetic Order Descending) |
Indicates that the PivotTable data is sorted in alphabetic order with descending values. |
|
descendingNatural (Natural Order Descending) |
Indicates that the PivotTable data is sorted in natural order with descending values. |
|
none (None) |
Indicates that the PivotTable data is not sorted. |
|
Referenced By |
|
set@sortType (§3.10.1.88) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_SortType">
<restriction base="xsd:string">
<enumeration value="none"/>
<enumeration value="ascending"/>
<enumeration value="descending"/>
<enumeration value="ascendingAlpha"/>
<enumeration value="descendingAlpha"/>
<enumeration value="ascendingNatural"/>
<enumeration value="descendingNatural"/>
</restriction>
</simpleType>