[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_FilterOperator (Filter Operator)

Operator enumerations for filtering.

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

equal (Equal)

Show results which are equal to criteria.

greaterThan (Greater Than)

Show results which are greater than criteria.

greaterThanOrEqual (Greater Than Or Equal)

Show results which are greater than or equal to criteria.

lessThan (Less Than)

Show results which are less than criteria.

lessThanOrEqual (Less Than Or Equal)

Show results which are less than or equal to criteria.

notEqual (Not Equal)

Show results which are not equal to criteria.

 

Referenced By

customFilter@operator3.3.2.2)

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

<simpleType name="ST_FilterOperator">

   <restriction base="xsd:string">

   <enumeration value="equal"/>

   <enumeration value="lessThan"/>

   <enumeration value="lessThanOrEqual"/>

   <enumeration value="notEqual"/>

   <enumeration value="greaterThanOrEqual"/>

   <enumeration value="greaterThan"/>

   </restriction>

</simpleType>