2.1.823 Part 4 Section 3.10.1.88, set (OLAP Set)

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

Office requires that the count attribute be less than 2147483648 or 4294967295 when number of items in the set is unknown.

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

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

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

Excel restricts the value of this attribute to be at least 0 and at most 1048576.

d.   The standard states that on and off are valid values of the queryField 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 does not specify a default value for the count attribute.

Excel uses a default value of 4294967295 for this attribute.

f.   The standard says that the count attribute specifies the number of tuples in the set.

Office assumes that this indicates the number of tuples in the resulting set rather than the tpls element.

Show: