3.1.4.45.4.1 SortType

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

An enumeration of the different types of sort order than can be applied to an AutoFilter column.

 <xs:simpleType name="SortType" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:restriction base="xs:string">
     <xs:enumeration value="None"/>
     <xs:enumeration value="Ascending"/>
     <xs:enumeration value="Descending"/>
     <xs:enumeration value="Toggle"/>
   </xs:restriction>
 </xs:simpleType>

The following table specifies the allowable values for the SortType simple type.

Value

Meaning

None

MUST NOT be used.

Ascending

Specifies an ascending order.

Descending

Specifies a descending order.

Toggle

If the current sort order applied to the AutoFilter is ascending order, then this value specifies a descending order. Otherwise, it specifies an ascending order.