2.1.775 Part 1 Section 18.10.1.60, n (Numeric)

a.   The standard does not define relation between @cp and the datasource type.

Office allows @cp only with OLAP PivotTables.

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

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

c.   The standard does not define relation between @c and the datasource type.

Office allows @c only for OLAP-based PivotTables.  If the value of pivotCacheDefinition@createdVersion is less than 3 this value shall not be specified.

d.   The standard does not specify a default value for the u attribute.

Excel uses a default value of false for this attribute.

e.   The standard does not restrict the value of @cp.

Office requires that @cp be equal to the count of child x elements and be less than or equal to the mappingCount of the corresponding cacheField element.

f.   The standard does not specify a default value for the f attribute.

Excel uses a default value of false for this attribute.

g.   The standard states that the values of the v attribute are defined by the XML Schema double datatype.

Excel does not allow the values of INF, -INF, or NaN on this attribute.

h.   The standard does not state when @f is valid.

In Office, @f is valid only when the parent of the n element is of CT_SharedItems type.

i.   The standard does not define relation of @u with CT_SharedItems node.

In Office, @u is used only when the n element's parent is of CT_SharedItems type.

j.   The standard states that @b applies to italics.

Office assumes that @b applies to bold.

k.   The standard does not place a restriction for on the value of the cp attribute.

In Office, the cp  attribute applies only when the node parent is sharedItems.

Show: