MS Office 2003 complexType DataValidationType

Derived Types
{urn:schemas-microsoft-com:office:excel}DataValidationType {urn:schemas-microsoft-com:office:excel}DataValidation (by type)

Abstract	false (This can be used in an instance)
Target Namespace	urn:schemas-microsoft-com:office:excel
Declared Namespaces	xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:rs=urn:schemas-microsoft-com:rowset xmlns:s=uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882 xmlns=urn:schemas-microsoft-com:office:excel

<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>

complexType {urn:schemas-microsoft-com:office:excel}DataValidationType

Source

Documentation