2.1.818 Part 1 Section 18.12.4, queryTableField (QueryTable Field)

a.   The standard states that the tableColumnId attribute specifies the unique identifier for the table column if the query table is attached to a table object rather than just a range in the sheet.

In Office, the tableColumnId attribute shall be 0 if the query table is attached to a range in the sheet.

b.   The standard states the possible values for the name attribute are defined by ST_Xstring simple type.

Office requires that the name attribute is a string 0-255 characters in length.

c.   The standard states no restrictions on value of the clipped attribute are stated.

Office requires that if the clipped attribute is true, the dataBound attribute shall also be true.

d.   The standard states no limitations on @fillFormulas.

Office requires that is @fillFormulas is true, @dataBound shall also be false.

e.   The standard states no limitations on @rowNumbers.

Office requires that if @rowNumbers is true, @dataBound shall also be true.

Show: