DataValidations Class
Defines the DataValidations Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:dataValidations.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.DataValidations
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(DataValidation), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class DataValidations _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As DataValidations
[ChildElementInfoAttribute(typeof(DataValidation), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class DataValidations : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- DataValidation <x14:dataValidation>
2.4.5 dataValidations
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_DataValidations element 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 UI. See Worksheet under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="dataValidations" type="CT_DataValidations"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.3 CT_DataValidations
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: dataValidations
A complex type that specifies a group of data validation items on the sheet. MUST contain less than or equal to 65534 elements. This complex type also specifies data validation properties of a sheet that are used by the Application UI.
Child Elements:
dataValidation : A CT_DataValidation element that specifies the properties for a single item of data validation defined on a range of the sheet.
Attributes:
disablePrompts : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all data validation input prompts are disabled for this sheet.
xWindow : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the x-coordinate (relative to the Application window) of the top-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65535. <11>
yWindow : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the y-coordinate (relative to the Application window) of the top-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65535. <12>
count : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of dataValidation children of this element.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_DataValidations">
<xsd:sequence>
<xsd:element name="dataValidation" type="CT_DataValidation" minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="disablePrompts" type="xsd:boolean" use="optional" default="false"/>
<xsd:attribute name="xWindow" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="yWindow" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.