2.6.4 CT_DataValidationFormula

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_DataValidation

CT_DataValidationFormula is a complex type that specifies a formula used in data validation.

Child Elements:

xm:f: An f element (section 2.4.3) that specifies a formula for the data validation. The formula MUST adhere to the grammar provided in section 2.2.2, with the following restrictions:

  • MUST NOT use the ref-infix-operator, local-cell-reference, bang-reference, bang-name, array-constant, sheet-range-reference, py-params, lambda-params , or structure-reference production rules.

  • MUST be an external-cell-reference if used by the formula1 element of the ancestor CT_DataValidation element (section 2.6.5), and the formula1 element of the ancestor CT_DataValidation element uses the external-cell-reference production rule, and the type attribute of the ancestor CT_DataValidation element is "list".

  • MUST NOT be an external-cell-reference that references more than one cell if used by the formula1 element of the ancestor CT_DataValidation element and the type attribute of the ancestor CT_DataValidation element is not "list".

  • MUST NOT be an external-cell-reference that references more than one cell if used by the formula2 element of the ancestor CT_DataValidation element.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_DataValidationFormula">
   <xsd:sequence>
     <xsd:element ref="xm:f" minOccurs="1" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).