[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

CT_DataValidation is a complex type that specifies data validation for a range on this sheet (1).

Child Elements:

formula1: A CT_DataValidationFormula element (section 2.6.4) that specifies the first formula for the data validation.

 If operator is "between" or "notBetween" and type is not "custom", "list", or "none", this formula is used as the lesser of two bounding values and MUST exist.

 If operator is not "between" or "notBetween", or type is "custom", this formula is the only formula and MUST exist.

 If operator is not "between" or "notBetween", or type is "custom" or "list", either formula is the only formula and MUST exist or CT_DataValidation MUST have a list (section 2.4.67) child element.

 If the type is "none", this formula MUST NOT exist.