2.1.766 Part 1 Section 18.10.1.44, i (Row Items)

  • Article

a.   The standard does not specify restrictions on the i attribute.

Office specifies that the i attribute should be 0 if the dataFields collection is empty and should be less than number of elements in that collection otherwise.

b.   The standard states that a value of default on the t attribute indicates a grand total as the last row item value.

Excel uses the definition from the ST_ItemType simple type for the definition of this value.

c.   The standard does not place restrictions on the value of the r attribute.

In Office, if the r attribute is not 0, then the sum of the r attribute and number of x attribute elements must be less or equal to the number of elements in the rowFields or colFields collections, depending on context. The r attribute shall not exceed the number of items in the previous row item.

d.   The standard does not specify the relationship of x elements to pivotFields.

Office defines the relationship between x elements and pivotFields as follows:

The v attribute of the x element shall be 1048832 (specifying that no item appears at this position) or a valid item index in its pivot field.

The axis index, of a child item x, is calculated as the value of r plus the index of the x element within the collection in this element. The field index is calculated as given by the x attribute of the field element, at the position given by the axis index, in either the colFields element ("[ISO/IEC-29500-1] §18.10.1.14; colFields"), if the parent of this element is colItems, or the rowFields element ("[ISO/IEC-29500-1] §18.10.1.81; rowFields"), if the parent of this element is rowItems.

If the field index is -2 valid item indexes, for the v attribute of the x child, shall be less than the number of elements in the dataFields collection ("[ISO/IEC-29500-1] §18.10.1.23; dataFields"). Otherwise valid item indexes, for the v attribute of the x child, shall be less than the number of elements in the items collection ("[ISO/IEC-29500-1] §18.10.1.46; items") of the pivotField, at the index given by the field index in the pivotFields ("[ISO/IEC-29500-1] §18.10.1.70; pivotFields").