<ST_SortType> (Set Sort Order)

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>