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>