2.1.791 Part 1 Section 18.10.1.85, s (Character Value)

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

Excel uses a default value of false for this attribute.

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

Excel uses a default value of false for this attribute.

c.   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.

d.   The standard does not define a relationship between the c attribute and the datasource type.

In Office, the c attribute is only used with OLAP-based PivotTables. If the value of pivotCacheDefinition@createdVersion is less than 3, this value shall not be specified.

e.   The standard does not state that @cp is required in certain cases.

Office requires that @cp shall 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 state that the presence of @cp is related to the datasource type.

In Office, @cp is specific to OLAP-based PivotTables.

g.   The standard does not define a relationship between @cp and the parent element of s.

In Office, @cp applies only when the parent of the s element is of type CT_SharedItems.

h.   The standard does not define a relationship between @f and the parent element of s.

In Office, @f applies only when the parent of the s element is of type CT_SharedItems.

i.   The standard does not define a relationship between @u and the parent element of s.

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

j.   The standard does not limit the length of the value of the v attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

Show: