Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.1.793 Part 4 Section 3.10.1.45, item (PivotTable Field Item)

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 states that on and off are valid values of the c attribute.

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

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

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

Excel does not allow these values on this attribute.

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

t.   The standard states that on and off are valid values of the m attribute.

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

v.   The standard states that on and off are valid values of the sd attribute.

Excel does not allow these values on this attribute.

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

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

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

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

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

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

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

Show:
© 2016 Microsoft