2.1.794 Part 1 Section 18.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 does not specify a default value for the count attribute.

Excel uses a default value of 4294967295 for this attribute.

e.   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: