Definition Type Complex Type
Name DataValidationType
Namespace urn:schemas-microsoft-com:office:excel
Abstract False
Documentation Contains the data validation criteria, input message, and error message elements of the specified range.
XSD Schema excel.xsd
XSD Schema Diagram
XSD Schema Code
<xsd:complexType xmlns:xsd="http://www.w3.org/2001/XMLSchema" 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 minOccurs="0" default="AnyValue" name="Type">
      <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 minOccurs="0" name="CellRangeList">
      <xsd:annotation>
        <xsd:documentation>Specifies whether a list of values is used for data validation.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="Qualifier">
      <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 minOccurs="0" name="UseBlank">
      <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 minOccurs="0" name="Min" type="xsd:string">
          <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 minOccurs="0" name="Max" type="xsd:string">
          <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 minOccurs="0" name="ComboHide">
          <xsd:annotation>
            <xsd:documentation>Suppresses the list of acceptable values.</xsd:documentation>
          </xsd:annotation>

        </xsd:element>

      </xsd:sequence>

    </xsd:choice>

    <xsd:element minOccurs="0" name="IMEMode">
      <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 minOccurs="0" name="InputHide">
      <xsd:annotation>
        <xsd:documentation>Specifies whether an input dialog box is displayed during data validation.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="InputTitle" type="xsd:string">
      <xsd:annotation>
        <xsd:documentation>Contains the title of an input dialog box displayed during data validation.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="InputMessage" type="xsd:string">
      <xsd:annotation>
        <xsd:documentation>Contains the input message displayed during data validation.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="ErrorHide">
      <xsd:annotation>
        <xsd:documentation>Specifies whether error messages are displayed during data validation.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="ErrorStyle">
      <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 minOccurs="0" name="ErrorMessage" type="xsd:string">
      <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 minOccurs="0" name="ErrorTitle" type="xsd:string">
      <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>
Child Elements
Name Type Min Occurs Max Occurs
Derivation Tree
[No Sub Types]
DataValidationType
    x:DataValidation
        x:DataValidation
        x:DataValidation
References
x:DataValidation
Generated using Liquid XML Studio by Liquid Technologies Ltd