DataValidationForumla1 class

2.6.4 CT_DataValidationFormula

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, 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] 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] section 2.1).

Reference