DataValidation element

Contains the data validation criteria, an input message, and elements related to error messages for a specified range.

Usage

      
<DataValidation />

    

Element Information

Element type DataValidationType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
Range Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source.
Type Specifies the type of axis scaling, chart, data source, 3-D shape, or trendline, the data validation constraints on data entered into a range, or the position of legend entries.
CellRangeList Specifies whether a list of values is used for data validation.
Qualifier Contains the qualifier of a condition in conditional text formatting and data validation.
UseBlank Specifies whether blank cells in a range are used when validating input data.
Min Specifies the minimum value to be used for tests that use the BETWEEN operator.
Max Specifies the maximum value to be used for tests that use the BETWEEN operator.
Value Specifies the value to be tested.
ComboHide Suppresses the list of acceptable values.
IMEMode Specifies the status of the Input Method Editor (IME).
InputHide Specifies whether an input dialog box is displayed during data validation.
InputTitle Contains the title of an input dialog box displayed during data validation.
InputMessage Contains the input message displayed during data validation.
ErrorHide Specifies whether error messages are displayed during data validation.
ErrorStyle Contains the style of a data validation error message.
ErrorMessage Contains the data validation error message that is displayed when invalid data is entered.
ErrorTitle Contains the title of an error dialog box displayed during data validation.

Attributes

None.

Definition

      
<xsd:element name="DataValidation" type="DataValidationType" >
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp