2.1.824 Part 4 Section 3.10.1.90, sharedItems (Shared Items)

a.   In the standard @maxValue is a double.

Office does not support the use of NaN, INF, or -INF for @maxValue.

b.   The standard states that on and off are valid values of the containsBlank attribute.

Excel does not allow these values on this attribute.

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

c.   The standard states that on and off are valid values of the containsDate attribute.

Excel does not allow these values on this attribute.

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

d.   The standard states that on and off are valid values of the containsInteger attribute.

Excel does not allow these values on this attribute.

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

e.   The standard states that on and off are valid values of the containsMixedTypes attribute.

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

g.   The standard states that on and off are valid values of the containsNumber attribute.

Excel does not allow these values on this attribute.

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

h.   The standard states that on and off are valid values of the containsSemiMixedTypes 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 states that on and off are valid values of the containsString attribute.

Excel does not allow these values on this attribute.

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

j.   The standard states that on and off are valid values of the longText attribute.

Excel does not allow these values on this attribute.

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

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

Office does not support the use of NaN, INF, or -INF for the minValue attribute.

l.   In the standard it states that a longText attribute value of false indicates when text is less than 255 characters.

Office interprets a longText attribute value of false to indicate when text is less than or equal to 255 characters.

m.   The standard describes when the attributes are not used in the load process.

Office checks these restrictions for individual attributes, not on the element as a whole. Restrictions are described in detail per attribute.

n.   In the standard relationships of @containsNumber with other attributes is not explicit.

In Office, @containsNumber shall be 1 or true when @containsInteger is specified. This value shall also be 1 or true when @minValue or @maxValue is specified.

o.   In the standard there is not an explicit order between @minValue and @maxValue.

In Office the value of @minValue shall be less than or equal to the value of @maxValue.

p.   The standard does not defined what mixed types are for the containsMixedTypes attribute.

In Office, the containsMixedTypes attribute assumes that boolean and error shall be considered part of the string type.

q.   The standard does not define what other values are for the containsSemiMixedTypes attribute.

Office expects that the containsSemiMixedTypes attribute is true when the field contains text, blank, boolean or error values.

r.   The standard states that when the containsString attribute equals 1, this field contains a text value.

In Office, boolean and error are considered strings in the context of the containsString attribute.

s.   In the standard, a value of 1 or true for the containsInteger attribute indicates this field contains integer values.

In Office, a value of 1 or true for the containsInteger attribute indicates this field contains only integer values and does not contain non-integer numeric values.

t.   The standard does not explicitly specify relationships for the minValue attribute.

In Office, the minValue attribute shall be present when the maxValue attribute is specified. The minValue attribute shall not be specified when the minDate or maxDate attributes are specified. If present, at least one child must be a n element.

u.   The standard does not explicitly specify relationships for @maxValue.

In Office, @maxValue shall be present when @minValue is specified.  @maxValue shall not be specified when @minDate or @maxDate are specified. If present, at least one child must be a n element.

v.   The standard does not explicitly specify relationships for @minDate.

In Office @minDate shall be present when @maxDate is specified. @minDate shall not be present when @minValue or maxValue are present. If present, at least one child must be a d element.

w.   The standard does not explicitly specify relationships for @maxDate.

In Office @maxDate must be present when @minDate is specified. @maxDate shall not be present when @minValue or @maxValue are present. If present, at least one child must be a d element.

x.   The standard states that the maxOccurs value for the choice statement including the m, n, b, e, s, and d elements is unbounded.

Excel limits the occurrences of this choice to 32500 when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 1048576 otherwise.

Show: