Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_DataValidation
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into formula2 in schema sml-sheet_xsd Drilldown into formula1 in schema sml-sheet_xsd Drilldown into sqref in schema sml-sheet_xsd Drilldown into prompt in schema sml-sheet_xsd Drilldown into promptTitle in schema sml-sheet_xsd Drilldown into error in schema sml-sheet_xsd Drilldown into errorTitle in schema sml-sheet_xsd Drilldown into showErrorMessage in schema sml-sheet_xsd Drilldown into showInputMessage in schema sml-sheet_xsd Drilldown into showDropDown in schema sml-sheet_xsd Drilldown into allowBlank in schema sml-sheet_xsd Drilldown into operator in schema sml-sheet_xsd Drilldown into imeMode in schema sml-sheet_xsd Drilldown into errorStyle in schema sml-sheet_xsd Drilldown into type in schema sml-sheet_xsdXSD Diagram of CT_DataValidation in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_DataValidation">
    <xsd:sequence>
        <xsd:element name="formula1" type="ST_Formula" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Formula 1</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="formula2" type="ST_Formula" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Formula 2</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="type" type="ST_DataValidationType" use="optional" default="none">
        <xsd:annotation>
            <xsd:documentation>Data Validation Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="errorStyle" type="ST_DataValidationErrorStyle" use="optional" default="stop">
        <xsd:annotation>
            <xsd:documentation>Data Validation Error Style</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="imeMode" type="ST_DataValidationImeMode" use="optional" default="noControl">
        <xsd:annotation>
            <xsd:documentation>IME Mode Enforced</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="operator" type="ST_DataValidationOperator" use="optional" default="between">
        <xsd:annotation>
            <xsd:documentation>Operator</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allowBlank" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Allow Blank</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDropDown" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Drop Down</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showInputMessage" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Input Message</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showErrorMessage" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Error Message</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="errorTitle" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Error Alert Text</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="error" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Error Message</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="promptTitle" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Prompt Title</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="prompt" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Input Prompt</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sqref" type="ST_Sqref" use="required">
        <xsd:annotation>
            <xsd:documentation>Sequence of References</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
formula1 nsM:formula1 0 1
formula2 nsM:formula2 0 1
Collapse Child Attributes:
Name Type Default Value Use
type nsM:type none Optional
errorStyle nsM:errorStyle stop Optional
imeMode nsM:imeMode noControl Optional
operator nsM:operator between Optional
allowBlank nsM:allowBlank false Optional
showDropDown nsM:showDropDown false Optional
showInputMessage nsM:showInputMessage false Optional
showErrorMessage nsM:showErrorMessage false Optional
errorTitle nsM:errorTitle Optional
error nsM:error Optional
promptTitle nsM:promptTitle Optional
prompt nsM:prompt Optional
sqref nsM:sqref Required
Collapse Derivation Tree:
Collapse References:
nsM:dataValidation
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0