| count: An unsignedInt attribute that specifies the number of dataValidation child elements of this element.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
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.
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.5 CT_DataValidation
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: CT_DataValidations
Dostları ilə paylaş: | 
