2.1.614 Part 1 Section 18.3.1.33, dataValidations (Data Validations)

  • Article

a.   The standard states that the values of the xWindow attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 65535.

b.   The standard states that the values of the count attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 65534.

c.   The standard states that the values of the yWindow attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 65535.

d.   The standard does not specify a default value for the xWindow attribute.

Excel uses a default value of 0 for this attribute.

e.   The standard does not specify a default value for the yWindow attribute.

Excel uses a default value of 0 for this attribute.

f.   The standard does not specify a default value for the count attribute.

Excel uses a default value of 0 for this attribute.

g.   The standard states that the maxOccurs value for the dataValidation child element is unbounded.

Excel limits the occurrences of this element to 65534.