2.1.818 Part 4 Section 3.10.1.78, rangePr (Range Grouping Properties)

a.   The standard states that on and off are valid values of the autoEnd 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 states that on and off are valid values of the autoStart 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 does not specify restrictions for @groupBy in case of parent/child relationship.

In Office, if this rangePr is a part of a fieldGroup with a parent field, the groupBy in the rangePr of the parent must have a value that is greater than the groupBy in this rangePr.

d.   The standard does not specify restrictions for @groupInterval.

In Office, @groupInterval must be greater than zero; if @groupBy does not equal range, the value must be an integer less than 32768.

e.   The standard does not specify restrictions for the @startNum and @endNum relationship.

In Office, @startNum shall be less than @endNum.

f.   The standard does not specify restrictions for the @startDate and @endDate relationship.

In Office, @startDate shall be less than @endDate.

g.   The standard does not specify restrictions for the startDate attribute and startNum or endNum attribute relationships.

In Office, the startDate attribute shall not be specified if the startNum or endNum attributes are specified.

h.   The standard does not specify restrictions for the endDate attribute and startNum or endNum attribute relationships.

Office requires that the endDate attribute shall not be specified if the startNum or endNum attributes are specified.

i.   The standard does not specify the relationship between the groupBy attribute and the startDate and endDate attributes.

In Office, if this value is not range, at least one of startDate or endDate shall be specified. Additionally, if this value is not range and the enclosing cacheField has databaseField equal to 1,  sharedItems element (“[ECMA-376] Part 4 §3.10.1.90; sharedItems (Shared Items)”) of the enclosing cacheField shall have containsDate equal to 1 and  containsNumber equal to 0; also, this cacheField shall have containsSemiMixedTypes equal to 0, otherwise it shall have containsMixedTypes equal to 0 and containsBlank equal to 0.

j.   In the standard no default behavior is specified for @endDate.

If @endDate is not specified, Office uses values in the sharedItems collection of the enclosing cacheField to calculate the ending value.

k.   In the standard no default behavior is specified for @startDate.

If @startDate is not specified, Office uses values in the sharedItems collection of the enclosing cacheField to calculate the starting value.

l.   In the standard, no default behavior is specified for the endNum attribute.

If the endNum attribute is not specified, Office uses values in the sharedItems collection of the enclosing cacheField to calculate the ending value.

m.   In the standard, no default behavior is specified for the startNum attribute.

If the startNum attribute is not specified, Office uses values in the sharedItems collection of the enclosing cacheField to calculate the starting value.

n.   The standard does not specify restrictions on data types for items of fields when the groupBy attribute equals range.

Office requires that the sharedItems element of the enclosing cacheField have a containsString attribute equal to 0 and a containsMixedTypes attribute equal to 0 when the value of the groupBy attribute equals range.

o.   The standard does not place any restrictions on the value of the groupBy attribute when the value of the containsMixedType attribute on the sharedItems element of the enclosing cacheField is 1.

Excel requires the value of the groupBy attribute to be range under this circumstance.

Show: