2.1.781 Part 4 Section 3.10.1.27, e (Error Value)

a.   The standard states that on and off are valid values of the f attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

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

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

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

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

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

Excel uses a default value of false for this attribute.

h.   The standard states that on and off are valid values of the u attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

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

Excel uses a default value of false for this attribute.

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

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

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

m.   The standard allows on as a valid value for the b attribute.

In Office, on is an invalid value for the b attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

n.   The standard allows on as a valid value for the i attribute.

In Office, on is an invalid value for the i attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

o.   The standard allows on as a valid value for the st attribute.

In Office, on is an invalid value for the st attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

p.   The standard allows on as a valid value for the un attribute.

In Office, on is an invalid value for the un attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

Show: