[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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>