2.1.613 Part 1 Section 18.3.1.32, dataValidation (Data Validation)

  • Article

a.   The standard does not limit the length of the value of the prompt attribute.

Excel restricts the value of this attribute to be at most 255 characters, after decoding.

b.   The standard states that the possible values for @sqref are defined by ST_Sqref simple type.

Office limits the number of references in @sqref to be between 1 and 32767 inclusive.

c.   The standard does not restrict the value of the error attribute.

Office restricts the length of the value of the error attribute to 224 characters.

d.   The standard does not limit the length of the value of the errorTitle attribute.

Office limits the length of the value of the errorTitle attribute to 32 characters.

e.   The standard states that there is no limit on length of the promptTitle attribute value.

Office limits the length of the promptTitle attribute value to 32 characters.