Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: DataValidationType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the data validation criteria, input message, and error message elements of the specified range.
Collapse XSD Schema Diagram:
Drilldown into ErrorTitle in schema excel_xsd Drilldown into ErrorMessage in schema excel_xsd Drilldown into ErrorStyle in schema excel_xsd Drilldown into ErrorHide in schema excel_xsd Drilldown into InputMessage in schema excel_xsd Drilldown into InputTitle in schema excel_xsd Drilldown into InputHide in schema excel_xsd Drilldown into IMEMode in schema excel_xsd Drilldown into ComboHide in schema excel_xsd Drilldown into Value in schema excel_xsd Drilldown into Max in schema excel_xsd Drilldown into Min in schema excel_xsd Drilldown into UseBlank in schema excel_xsd Drilldown into Qualifier in schema excel_xsd Drilldown into CellRangeList in schema excel_xsd Drilldown into Type in schema excel_xsd Drilldown into Range in schema excel_xsdXSD Diagram of DataValidationType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="DataValidationType">
    <xsd:annotation>
        <xsd:documentation>Contains the data validation criteria, input message, and error message elements of the specified range.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Range" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Type" default="AnyValue" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Custom" />
                    <xsd:enumeration value="Date" />
                    <xsd:enumeration value="Decimal" />
                    <xsd:enumeration value="List" />
                    <xsd:enumeration value="TextLength" />
                    <xsd:enumeration value="Time" />
                    <xsd:enumeration value="Whole" />
                    <xsd:enumeration value="AnyValue" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="CellRangeList" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a list of values is used for data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Qualifier" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the qualifier of a condition in conditional text formatting and data validation.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Between" />
                    <xsd:enumeration value="NotBetween" />
                    <xsd:enumeration value="Equal" />
                    <xsd:enumeration value="NotEqual" />
                    <xsd:enumeration value="Greater" />
                    <xsd:enumeration value="Less" />
                    <xsd:enumeration value="GreaterOrEqual" />
                    <xsd:enumeration value="LessOrEqual" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="UseBlank" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether blank cells in a range are used when validating input data.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:choice>
            <xsd:sequence>
                <xsd:element name="Min" type="xsd:string" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the minimum value to be used for tests that use the BETWEEN operator.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="Max" type="xsd:string" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the maximum value to be used for tests that use the BETWEEN operator.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
            </xsd:sequence>
            <xsd:sequence>
                <xsd:element name="Value" type="xsd:string">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the value to be tested.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="ComboHide" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Suppresses the list of acceptable values.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
            </xsd:sequence>
        </xsd:choice>
        <xsd:element name="IMEMode" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the status of the Input Method Editor (IME).</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="0" />
                    <xsd:enumeration value="1" />
                    <xsd:enumeration value="2" />
                    <xsd:enumeration value="3" />
                    <xsd:enumeration value="4" />
                    <xsd:enumeration value="5" />
                    <xsd:enumeration value="6" />
                    <xsd:enumeration value="7" />
                    <xsd:enumeration value="8" />
                    <xsd:enumeration value="9" />
                    <xsd:enumeration value="10" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="InputHide" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether an input dialog box is displayed during data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="InputTitle" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the title of an input dialog box displayed during data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="InputMessage" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the input message displayed during data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ErrorHide" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether error messages are displayed during data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ErrorStyle" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the style of a data validation error message.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Info" />
                    <xsd:enumeration value="Stop" />
                    <xsd:enumeration value="Warn" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="ErrorMessage" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the data validation error message that is displayed when invalid data is entered.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ErrorTitle" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the title of an error dialog box displayed during data validation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Range x:Range (1) (1)
Type x:Type 0 (1)
CellRangeList x:CellRangeList 0 (1)
Qualifier x:Qualifier 0 (1)
UseBlank x:UseBlank 0 (1)
Min x:Min 0 (1)
Max x:Max 0 (1)
Value x:Value (1) (1)
ComboHide x:ComboHide 0 (1)
IMEMode x:IMEMode 0 (1)
InputHide x:InputHide 0 (1)
InputTitle x:InputTitle 0 (1)
InputMessage x:InputMessage 0 (1)
ErrorHide x:ErrorHide 0 (1)
ErrorStyle x:ErrorStyle 0 (1)
ErrorMessage x:ErrorMessage 0 (1)
ErrorTitle x:ErrorTitle 0 (1)
Collapse Derivation Tree:
Collapse References:
x:DataValidation
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0