2.1.830 Part 4 Section 3.10.2.1, reference (Reference)

a.   The standard defines @field (Field Index) values range as unsignedInt and says a value of -2 indicates the data field.

Office uses the value 4294967294 (a valid unsignedInt) to specify the data field and the @v in the x elements represent indices into the dataFields collection.

b.   The standard defines @field values range as unsignedInt.

Office requires that if the pivotArea@cacheIndex is 0, then the value shall be a valid index in the pivotFields in the pivotTable, and, unless byPosition is 1, @v in the x elements represent indices into items collection of the pivotField.

c.   The standard states that on and off are valid values of the avgSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

d.   The standard states that on and off are valid values of the countASubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

e.   The standard states that on and off are valid values of the countSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

f.   The standard states that on and off are valid values of the defaultSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

g.   The standard states that on and off are valid values of the maxSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

h.   The standard states that on and off are valid values of the minSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

i.   The standard states that on and off are valid values of the productSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

j.   The standard states that on and off are valid values of the relative attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

k.   The standard states that on and off are valid values of the selected attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

l.   The standard states that on and off are valid values of the stdDevPSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

m.   The standard states that on and off are valid values of the stdDevSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

n.   The standard states that on and off are valid values of the sumSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

o.   The standard states that on and off are valid values of the varPSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

p.   The standard states that on and off are valid values of the varSubtotal attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

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

Office requires that if the pivotArea@cacheIndex is 1 the value shall be a valid index in the cacheFields in the pivot cache and the v attribute in the x elements represent indices into sharedItems collection of the cacheField.

r.   The standard states that on and off are valid values of the byPosition attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

Show: