2.1.857 Part 1 Section 18.16.2, Map (XML Mapping Properties)

  • Article

a.   The standard indicates that @Append type is xsd:boolean.

Office requires @Append to be true or false (not 1/0).

b.   The standard indicates that @ShowImportExportValidationErrors type is xsd:boolean.

Office requires @ShowImportExportValidationErrors to be true or false (not 1/0).

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

Excel restricts the value of this attribute to be true or false.

d.   The standard indicates that @PreserveSortAFLayout type is xsd:boolean.

Office requires @PreserveSortAFLayout to be true or false (not 1/0).

e.   The standard indicates that @PreserveFormat type is xsd:boolean.

Office requires @PreserveFormat to be true or false (not 1/0).

f.   The standard does not specify a maximum length restriction for the name attribute.

Office limits the name attribute length to less than 65536 characters.

g.   The standard does not specify a maximum length restriction for @RootElement.

Office limits @RootElement to less than 65536 characters.

h.   The standard does not specify a maximum for @ID.

Office limits @ID to be less than 2147483648 and greater than 0.