2.1.782 Part 1 Section 18.10.1.67, pivotCacheDefinition (PivotCache Definition)

  • Article

a.   The standard doesn't specify maxLength for @refreshedBy.

In Office, the maxLength for @refreshedBy is 255.

b.   The standard doesn't specify any restrictions for @backgroundQuery.

In Office, the @backgroundQuery shall be 0 for non-external data sources.

c.   The standard does not specify any restrictions for the optimizeMemory attribute.

In Office, the optimizeMemory attribute must be 0 or false for non-external and non-ODBC data sources.

d.   The standard does not specify any restrictions for the refreshedVersion attribute.

In Office, the refreshedVersion attribute shall not be less than the minRefreshableVersion attribute.

e.   The standard does not specify any restrictions for the id attribute.

In Office, the id attribute must not be empty if the saveData attribute is 1 and the invalid attribute is 0.

f.   The standard does not define application defined behavior when the missingItemsLimit attribute is not present.

If this number is not specified, Office sets the threshold automatically based on the number of items.

g.   The standard does not define a relation between this @tupleCache and the tupleCache child element.

In Office, if @tupleCache has a value of 0, then pivotCacheDefinition shall not contain tupleCache element.

h.   The standard does not place any restrictions on the value of the backgroundQuery attribute with respect to connection element.

Office requires the backgroundQuery attribute match the value of background on the related connection element.