2.1.755 Part 1 Section 18.10.1.27, e (Error Value)

  • Article

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

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

In Office, the c attribute applies only to OLAP-based PivotTables when the pivotCacheDefinition element attribute createdVersion is greater than or equal to 3.

c.   The standard does not define the relation between the cp attribute and child elements.

In Office, the value of the cp attribute shall be equal to the count of child elements and be less than or equal to the @mappingCount of the corresponding cacheField element.

d.   The standard does not define the relation between the cp attribute and the datasource type.

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

e.   The standard does not define relation between the cp attribute and sharedItems node.

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

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 does not specify a default value for the u attribute.

Excel uses a default value of false for this attribute.

h.   The standard does not normatively define valid error values for the v attribute.

Office implements the following error values:

  • #DIV/0!

  • #NAME?

  • #VALUE!

  • #NULL!

  • #NUM!

  • #REF!

  • #N/A

  • #GETTING_DATA

i.   The standard does not define relation between the f attribute and sharedItems node.

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

j.   The standard does not define relation between the u attribute and sharedItems node.

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