2.4.43 ST_enmFilterItemType

  • Article

Referenced by: CT_item, CT_Cell

This enumeration defines whether filtering or sorting is applied as well as the sort order if sorting is applied. It is used on the DropDownType attribute (2) in a Cell and the Type attribute (2) in an item.

The following table shows the enumeration values for this type.

Value

Meaning

None

No filter or sort is applied.

Filtered

A filter is applied to the worksheet cells.

SortedAsc

Worksheet cells are sorted in ascending order.

SortedDesc

Worksheet cells are sorted in descending order.

BothAsc

A filter is applied to the worksheet cells and they are sorted in ascending order.

BothDesc

A filter is applied to the worksheet cells and they are sorted in descending order.

Sorted

Worksheet cells are sorted but the sort order (2) is not known.

Both

A filter is applied to the worksheet cells and they are sorted but the sort order is not known.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this simple type.

 <xs:simpleType name="ST_enmFilterItemType">
   <xs:restriction base="xs:string">
     <xs:enumeration value="None"/>
     <xs:enumeration value="Filtered"/>
     <xs:enumeration value="SortedAsc"/>
     <xs:enumeration value="SortedDesc"/>
     <xs:enumeration value="BothAsc"/>
     <xs:enumeration value="BothDesc"/>
     <xs:enumeration value="Sorted"/>
     <xs:enumeration value="Both"/>
   </xs:restriction>
 </xs:simpleType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).