Definition Type: Element
Name: dataValidation
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_DataValidation
Containing Schema: sml-sheet.xsd
MinOccurs 1
MaxOccurs unbounded
Abstract
Documentation:
Data Validation
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_xsd Drilldown into CT_DataValidation in schema sml-sheet_xsdXSD Diagram of dataValidation in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:element name="dataValidation" type="CT_DataValidation" minOccurs="1" maxOccurs="unbounded">
    <xsd:annotation>
        <xsd:documentation>Data Validation</xsd:documentation>
    </xsd:annotation>
</xsd:element>
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: