2.1.712 Part 4 Section 126.96.36.199, xmlColumnPr (XML Column Properties)
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.
d. The standard states that extLst is a child element of xmlColumnPr.
Office will move an extLst element under xmlColumnPr into the parent element of xmlColumnPr (tableColumn). If an extlist child element is already present on tableColumn, the file will become invalid once saved.
This note applies to the following products: 2007, 2007 SP1, 2007 SP2.