2.1.748 Part 1 Section 18.10.1.21, d (Date Time)

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 @c's relation with the datasource type.

In Office, @c applies only to OLAP-based PivotTables and only when pivotCacheDefinition@createdVersion is 3 or greater.

e.   The standard does not define the relationship between the cp attribute and the datasource type.

In Office, the cp attribute applies to OLAP-based PivotTables only.

f.   The standard does not define the relation between the cp attribute and the sharedItems parent.

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

g.   The standard does not define the relation between @f and the sharedItems parent.

In Office, @f applies when the parent is sharedItems.

h.   The standard does not define restrictions on the value of @cp.

In Excel, @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.

i.   The standard does not define the relation between @u and the sharedItems parent.

In Excel, @u applies when the parent is sharedItems.

Show: