2.4.7 dataValidations

  • Article

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

The dataValidations element is a CT_DataValidations type element, as specified in section 2.6.3, that specifies a group of data validation items on the sheet. This element also specifies data validation properties of a sheet that are used by the application user interface. See section 2.2.4.12 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016].

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

 <xsd:element name="dataValidations" type="CT_DataValidations"/>

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