<ST_SortBy> (Sort By)

Specifies what to sort by. In many cases a range of cells are sorted by their values. However, cells can also be sorted by their background color, font color, and type of icon in the cell.

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

<cellColor> (Sort by Cell Color)

Sort by cell color

<fontColor> (Sort by Font Color)

Sort by font color

<icon> (Sort by Icon)

Sort by icon

<value> (Value)

Sort by value

Referenced By

<sortCondition@sortBy>3.3.1.88)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_SortBy">
	<restriction base="xsd:string">
	<enumeration value="value"/>
	<enumeration value="cellColor"/>
	<enumeration value="fontColor"/>
	<enumeration value="icon"/>
	</restriction>
</simpleType>