dataValidation: A CT_DataValidation element (section 2.6.5) that specifies the properties for a single data validation item defined on a range of the sheet (1).
Attributes:
disablePrompts: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all data validation input prompts are disabled for this sheet (1).
Value
Meaning
"true"
All data validation input prompts are disabled for this sheet (1).
"false"
The data validation input prompts are enabled for this sheet (1).
xWindow: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the x-coordinate, relative to the application window, of the upper-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65,535. <6>
yWindow: An unsignedInt attribute that specifies the y-coordinate, relative to the application window, of the upper-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65,535. <7>
