[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_DataValidationOperator (Data Validation Operator)

The relational operator used in data validation.

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

between (Between)

Data validation which checks if a value is between two other values.

equal (Equal)

Data validation which checks if a value is equal to a specified value.

greaterThan (Greater Than)

Data validation which checks if a value is greater than a specified value.

greaterThanOrEqual (Greater Than Or Equal)

Data validation which checks if a value is greater than or equal to a specified value.

lessThan (Less Than)

Data validation which checks if a value is less than a specified value.

lessThanOrEqual (Less Than Or Equal)

Data validation which checks if a value is less than or equal to a specified value.

notBetween (Not Between)

Data validation which checks if a value is not between two other values.

notEqual (Not Equal)

Data validation which checks if a value is not equal to a specified value.

 

Referenced By

dataValidation@operator (§3.3.1.30)

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

<simpleType name="ST_DataValidationOperator">

   <restriction base="xsd:string">

   <enumeration value="between"/>

   <enumeration value="notBetween"/>

   <enumeration value="equal"/>

   <enumeration value="notEqual"/>

   <enumeration value="lessThan"/>

   <enumeration value="lessThanOrEqual"/>

   <enumeration value="greaterThan"/>

   <enumeration value="greaterThanOrEqual"/>

   </restriction>

</simpleType>