2.1.681 Part 1 Section 18.5.1.3, tableColumn (Table Column)

  • Article

a.   The standard says the maximum string length of the name attribute is unlimited.

In Office, the name attribute string length must be less than or equal to 255 characters.

b.   The standard says the maximum string length of the uniqueName attribute is unlimited.

In Excel, the string length of the uniqueName attribute must be less than or equal to 255.

c.   The standard specifies that the totalsRowLabel attribute shall be ignored unless totalRowFunction is none.

In Office, the totalsRowLabel attribute shall be absent if totalsRowFunction has the value custom.

d.   The standard says the @headerRowCellStyle maximum string length is unlimited.

In Office, the headerRowCellStyle length must be between 1 and 255 characters inclusive.

e.   The standard says the @totalsRowCellStyle maximum string length is unlimited.

In Office the length of @totalsRowCellStyle shall be between 1 and 255 inclusive.

f.   The standard does not have requirements about the presence of the headerRowCellStyle attribute.

In Office, headerRowCellStyle attribute shall be absent if the enclosing table element's headerRow attribute value is greater than or equal to 1.

g.   The standard specifies the queryTableFieldId attribute as an unsignedInt datatype.

In Office, the queryTableFieldId attribute must be greater than zero.

h.   The standard says the @id value range is defined as unsigned integer.

In Office the value of @id must be greater than zero.

i.   The standard does not specify any relationship between the value of the name attribute and cell contents.

In Office, if the enclosing table element's headerRowCount attribute has a value greater than or equal to 1, then this attribute must have the same value as the cell it occupies.

j.   The standard says the maximum string length of the totalsRowLabel attribute is unlimited.

In Office, the maximum string length of the totalsRowLabel attribute must be less than or equal to 32767.

k.   The standard does not specify when the headerRowDxfId attribute shall be absent.

In Office, the headerRowDxfId attribute shall be absent if the enclosing table element's headerRow attribute value is greater than or equal to 1.

l.   The standard says the @dataCellStyle maximum string length is unlimited.

In Office, the @dataCellStyle length must be between 1 and 255 characters inclusive.

m.   The standard does not specify a relationship between the queryTableFieldId attribute and @tableType.

In Office, the queryTableFieldId attribute shall be absent when the enclosing table element's tableType attribute equals queryTable.

n.   The standard does not specify the totalsRowFunction attribute relationships.

In Office, if the table element attribute totalsRowCount is not 0, the totalsRowFunction attribute shall match the formula of the occupied cell and be of the form SUBTOTAL(<function number>,<ref>), unless the value is none or custom.  A value of none implies no formula.