2.1.767 Part 1 Section 18.10.1.45, item (PivotTable Field Item)

  • Article

a.   The standard states that the s attribute specifies if the item has a character value.

Excel uses the s attribute to specify if the item has a manual filter applied.

b.   The standard does not require any ordering of the child item elements.

In Office, any item elements that have the t attribute equal to the default value must appear before item elements with other values.

c.   The standard does not restrict the c attribute to OLAP PivotTables.

Excel allows the c attribute only for OLAP PivotTables.

d.   The standard does not restrict the d attribute to OLAP PivotTables.

Excel allows the d attribute for OLAP PivotTables only.

e.   The standard does not restrict the e attribute to OLAP PivotTables only.

Excel allows the e attribute for OLAP PivotTables only.

f.   The standard does not restrict the f attribute to non-OLAP PivotTables.

Excel allows the f attribute in non-OLAP PivotTables only.

g.   The standard does not restrict the h attribute to non-OLAP PivotTables.

Excel allows the h attribute in non-OLAP PivotTables only.

h.   The standard does not restrict the m attribute to non-OLAP PivotTables.

Excel allows the m attribute in non-OLAP PivotTables only.

i.   The standard does not restrict the s attribute to OLAP PivotTables.

Excel allows the s attribute in OLAP PivotTables only.

j.   The standard does not restrict the sd attribute to non-OLAP PivotTables.

Excel allows the sd attribute in non-OLAP PivotTables only.

k.   The standard restricts the x attribute to non-OLAP PivotTables only.

Excel allows the x attribute in both OLAP and non-OLAP PivotTables.

l.   The standard states that the sd attribute indicates whether the details are hidden for an item.

Excel uses the sd attribute to indicate whether the item is expanded.  A value of true indicates item details are shown.  A value of false indicates item details are hidden.

m.   The standard does not specify when the x attribute is required.

Excel requires the x attribute when the value of the t attribute is data.

n.   The standard states that the x attribute specifies an index to an item in the pivotFields collection.

Excel uses the x attribute to specify an index to an item in the sharedItems collection for this pivotField.

o.   The standard does not specify when the x attribute values should be unique for item elements in an items collection.

Excel requires the x attribute values to be unique for item elements in an items collection.

p.   The standard states that the m attribute indicates whether the item's value is missing.

Excel uses the m attribute to indicate whether the item itself is missing from the source data.

q.   The standard does not restrict the length of the n attribute.

Office requires that the n attribute be no longer than 32767 characters, or 255 characters when the PivotTable version is less than 3.

r.   The standard does not restrict the value of the n attribute.

Office requires for non-OLAP PivotTables that, if present, the value of the n attribute be unique within the containing pivotField.

s.   The standard does not restrict the value of the t attribute with respect to other attributes.

Office requires that the f, h, m, and d attributes be the default values if the t attribute has a value other than data.

t.   The standard does not restrict the possible values for the t attribute within ST_ItemType.

Office does not allow blank or grand as values for the t attribute in the item element.