Export (0) Print
Expand All
Expand Minimize

2.1.671 Part 1 Section 18.5.1.2, table (Table)

a. The standard states that the values of the id attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at least 1 and at most 4294967294.

b. The standard does not limit the length of the value of the name attribute.

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

c. The standard does not describe what happens if the name attribute value is the empty string or the name attribute is not present.

Office, if this attribute is not specified or the value is an empty string, the value will be set to the value specified for the required displayName attribute.

d. The standard does not specify a default value for the connectionId attribute.

Excel uses a default value of 0 for this attribute.

e. In the standard there are no limits on when the connectionId attribute can be present.

In Office, this attribute must not be specified or the specified value must be 0 if tableType is not xml.

f. In the standard no relationship between @totalsRowCount and @totalRowShown is specified.

In Office, if @totalsRowCount equals 1, then totalsRowShown must be true.

g. The standard does not limit the length of the value of the comment attribute.

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

h. The standard only limits the @ref to include the totals row.

In Office, the count of rows for @ref shall be equal to or greater than the sum of rows specified by: @headerRowCount, @insertRow, and @totalsRowCount. Additionally, @ref must not overlap with another Table or auto-filter on the same worksheet.

i. The standard does not limit the length of the value of the dataCellStyle attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters.

j. The standard does not limit the length of the value of the headerRowCellStyle attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters.

k. The standard does not limit the length of the value of the totalsRowCellStyle attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters.

l. The standard states that the values of the connectionId attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 2147483647.

Show:
© 2014 Microsoft