| SpreadsheetML Schemas | Generated using Liquid XML Studio by Liquid Technologies Ltd |
| 12 October 2007 |
| 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: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> |
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
[No Sub Types] DataValidationType x:DataValidation x:DataValidation x:DataValidation |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| x:DataValidation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Generated using Liquid XML Studio by Liquid Technologies Ltd | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||