<ST_DataValidationType> (Data Validation Type)

Specifies the type of data validation used to validate user input.

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

<custom> (Custom)

Data validation which uses a custom formula to check the cell value.

<date> (Date)

Data validation which checks for date values satisfying the given condition.

<decimal> (Decimal)

Data validation which checks for decimal values satisfying the given condition.

<list> (List)

Data validation which checks for a value matching one of list of values.

<none> (None)

No data validation.

<textLength> (Text Length)

Data validation which checks for text values, whose length satisfies the given condition.

<time> (Time)

Data validation which checks for time values satisfying the given condition.

<whole> (Whole Number)

Data validation which checks for whole number values satisfying the given condition.

Referenced By

<dataValidation@type> (§3.3.1.30)

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

<simpleType name="ST_DataValidationType">
	<restriction base="xsd:string">
	<enumeration value="none"/>
	<enumeration value="whole"/>
	<enumeration value="decimal"/>
	<enumeration value="list"/>
	<enumeration value="date"/>
	<enumeration value="time"/>
	<enumeration value="textLength"/>
	<enumeration value="custom"/>
	</restriction>
</simpleType>