2.1.799 Part 1 Section 18.10.1.92, tpl (Tuple)

  • Article

a.   The standard does not require that @fld is mutually exclusive with @hier in a SpreadsheetML document.

Office requires that @fld and @heir be mutually exclusive in SpreadsheetML documents.

b.   The standard does not state that @fld has restrictions beyond unsignedInt.

Office expects that @fld is a zero-based index and shall be less than the number of items in the cacheFields collection.

c.   The standard does not place any restrictions on the value of the hier attribute.

Office expects that the hier attribute is a zero-based index and shall be less than the number of items in the cacheHierarchies collection.

d.   The standard does not specify restrictions for the item attribute.

If the value for the fld attribute is specified, then the value for this attribute shall be less than the number of items in the sharedItems collection, defined in sharedItems ("[ISO/IEC-29500-1] §18.10.1.90; sharedItems (Shared Items)").

If the value for the hier attribute is specified, then the value for this attribute shall either be equal to one of the special values 4294967294/4294967295 or it shall be less than number of items in the sets collection defined in sets ("[ISO/IEC-29500-1] §18.10.1.89; sets (Sets)").

The special value of 4294967294 implies that this is the all member of the hierarchy.

The special value of 4294967295 implies that this is the default member of the hierarchy.