2.1.684 Part 1 Section 18.5.1.7, xmlColumnPr (XML Column Properties)

  • Article

a.   The standard does not specify a maximum length for @xpath.

Office requires the decoded string length of @xpath to be less than 32000.

b.   The standard specifies that the mapId attribute has the value range of an xs:unsignedInt datatype.

In Excel, the mapId attribute must be greater than 0 and less than 2147483647.

c.   The standard states that the denormalized attribute is true if it has been filled down (denormalized) and false otherwise.

The denormalized attribute does not have any effect on the way Office behaves. Excel always denormalizes non-repeating nodes when mapped to a Table's column.