2.1.642 Part 1 Section 18.3.1.69, pivotSelection (PivotTable Selection)

  • Article

a.   The standard does not specify any relationships for the data attribute.

Office requires that the data attribute be false when the label attribute is true.

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

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

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

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

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

In Excel, if the axis attribute equals axisRow, then the dimension attribute must be less than number of elements in the rowFields collection. If the axis attribute equals axisCol, then the dimension attribute must be less than number of elements in the columnFields collection. If the axis attribute equals axisPage, then the dimension attribute equals 0.

e.   The standard states that the values for the min attribute are defined by the XML Schema unsignedInt datatype.

In Excel, if the axis attribute equals axisRow, then the min attribute must be less than the number of elements in the rowItems collection. If the axis attribute equals axisCol, then the min attribute must be less than the number of elements in the colItems collection. When the axis attribute equals axisPage, then the min attribute must be 0.

f.   The standard states that @max is not restricted beyond unsigned int.

In Excel, if @axis=axisRow, @max shall be less than the number of elements in rowItems collection. If @axis=axisCol, @max shall be less than the number of elements in colItems. When @axis=axisPage then @max shall be 0.

g.   The standard does not limit @start beyond unsigned int.

Office requires that @min < @start < @max+1.

h.   The standard does not define the valid set of values for the activeRow or the activeCol attributes.

Office requires that the following conditions be true:

  • If axis is set to axisRow, then the valid set of values for the activeRow or activeCol attributes should be within the Row axis area.

  • If axis is set to axisCol, then the valid set of values for the activeRow or activeCol attributes should be within the Column axis area.

  • If axis is set to axisPage, then the valid set of values for the activeRow or activeCol attributes should be within the Page/Report Filter axis area.

i.   The standard defines values for the pane attribute.

In Office, topLeft is interpreted as bottomRight and vice versa.

j.   The standard states that the r:id attribute is optional.

Excel requires this attribute.

k.   The standard states that the axis attribute has a valid value of axisPage.

Office will report a valid file as corrupt if axis is equal to axisPage.

l.   The standard states that the valid values for the axis attribute are defined by the ST_Axis simple type.

Office does not allow the axis attribute to equal axisValue.