Export (0) Print
Expand All
Expand Minimize

2.1.810 Part 4 Section 3.10.1.69, pivotField (PivotTable Field)

a. The standard states that on and off are valid values of the includeNewItemsInFilter 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 does not specify behavior if @axis is not present.

Office specifies if @axis is not present, the field does not appear in the row, column or page regions of the PivotTable.

c. The standard does not restrict valid values for the axis attribute.

In Office, axisValues shall not be used for the axis attribute.

d. The standard does not specify a default value for the numFmtId attribute.

Excel uses a default value of 0 for this attribute.

e. The standard does not specify a default value for the dataSourceSort attribute.

Excel uses a default value of false for this attribute.

f. The standard does not define the meaning of the absence of @rankBy.

Office assumes if @rankBy is not present, this indicates that no data field will be used by AutoShow for ranking.

g. The standard states that on and off are valid values of the allDrilled 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 autoShow 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 avgSubtotal 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 compact 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 on and off are valid values of the countASubtotal attribute.

Excel does not allow these values on this attribute.

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

l. The standard states that on and off are valid values of the countSubtotal attribute.

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

n. The standard states that on and off are valid values of the dataSourceSort attribute.

Excel does not allow these values on this attribute.

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

o. The standard states that on and off are valid values of the defaultAttributeDrillState 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 defaultSubtotal 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 dragOff 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 dragToCol 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 dragToData 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 dragToPage 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 dragToRow 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 hiddenLevel 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 states that on and off are valid values of the hideNewItems attribute.

Excel does not allow these values on this attribute.

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

x. The standard states that on and off are valid values of the insertBlankRow attribute.

Excel does not allow these values on this attribute.

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

y. The standard states that on and off are valid values of the insertPageBreak attribute.

Excel does not allow these values on this attribute.

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

z. The standard states that on and off are valid values of the maxSubtotal attribute.

Excel does not allow these values on this attribute.

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

aa. The standard states that on and off are valid values of the measureFilter attribute.

Excel does not allow these values on this attribute.

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

bb. The standard states that on and off are valid values of the minSubtotal attribute.

Excel does not allow these values on this attribute.

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

cc. The standard states that on and off are valid values of the multipleItemSelectionAllowed attribute.

Excel does not allow these values on this attribute.

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

dd. The standard states that on and off are valid values of the nonAutoSortDefault attribute.

Excel does not allow these values on this attribute.

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

ee. The standard states that on and off are valid values of the outline attribute.

Excel does not allow these values on this attribute.

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

ff. The standard states that on and off are valid values of the productSubtotal attribute.

Excel does not allow these values on this attribute.

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

gg. The standard states that on and off are valid values of the serverField attribute.

Excel does not allow these values on this attribute.

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

hh. The standard states that on and off are valid values of the showAll attribute.

Excel does not allow these values on this attribute.

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

ii. The standard states that on and off are valid values of the showDropDowns attribute.

Excel does not allow these values on this attribute.

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

jj. The standard states that on and off are valid values of the showPropAsCaption attribute.

Excel does not allow these values on this attribute.

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

kk. The standard states that on and off are valid values of the showPropCell attribute.

Excel does not allow these values on this attribute.

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

ll. The standard states that on and off are valid values of the showPropTip attribute.

Excel does not allow these values on this attribute.

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

mm. The standard states that on and off are valid values of the stdDevPSubtotal attribute.

Excel does not allow these values on this attribute.

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

nn. The standard states that on and off are valid values of the stdDevSubtotal attribute.

Excel does not allow these values on this attribute.

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

oo. The standard states that on and off are valid values of the subtotalTop attribute.

Excel does not allow these values on this attribute.

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

pp. The standard states that on and off are valid values of the sumSubtotal attribute.

Excel does not allow these values on this attribute.

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

qq. The standard states that on and off are valid values of the topAutoShow attribute.

Excel does not allow these values on this attribute.

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

rr. The standard states that on and off are valid values of the varPSubtotal attribute.

Excel does not allow these values on this attribute.

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

ss. The standard states that on and off are valid values of the varSubtotal attribute.

Excel does not allow these values on this attribute.

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

tt. The standard does not mention any relationship between the value of the dataField attribute and dataField elements.

Office requires that if the dataField attribute is true and this pivotTable is not an OLAP pivotTable, then there must be at least one matching dataField element on this pivotTable with an fld attribute equal to this element's index within its parent element.

uu. The standard says that for @nonAutoSortDefault, a value of 1 or true indicates that an AutoSort operation will be applied to the field.

In Office, a value of 1 or true indicates a simple data sort operation will be applied to the field.

vv. The standard does not require a relationship between the axis attribute and rowFields.

Office requires that if the axis attribute equals axisRow and this pivotTable is not an OLAP pivotTable, then there must be a field element in the rowFields collection with its x attribute set to the index of this pivotField.

ww. The standard does not require a relationship between the axis attribute and colFields.

Office requires that if the axis attribute equals axisCol and this pivotTable is not an OLAP pivotTable, then there must be a field element in the colFields collection with its x attribute set to the index of this pivotField.

xx. The standard does not require a relationship between the axis attribute and pageFields.

Office requires that if the axis attribute equals axisPage and this pivotTable is not an OLAP pivotTable, then there shall be a pageField element on this pivotTable with the fld attribute set to this pivotField's index.

yy. The standard does not define a relationship between the dataField attribute and the cacheHierarchy element.

Office requires that if the dataField attribute equals 1 and this is an OLAP pivotTable, then the cacheField on the associated pivotCache with the same index as this element shall exist and have a hierarchy attribute which will refer to a cacheHierarchy element with its measure attribute equal to 1.

zz. The standard does not require a relationship between the axis attribute and cacheHierarchy.

Office specifies if the axis attribute is present and this is an OLAP pivotTable, then the cacheField on the associated pivotCache with the same index as this element shall have a hierarchy attribute which will refer to a cacheHierarchy element with its measure attribute equal to 0.

aaa. The standard does not limit the length of the value of the name attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

bbb. The standard does not limit the length of the value of the subtotalCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

ccc. The standard does not limit the length of the value of the uniqueMemberProperty attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

ddd. The standard does not place a uniqueness restriction on the value of @name.

Office requires @name to be unique for non-OLAP PivotTables.

eee. The standard does not place any restrictions on the relationship between the serverField attribute and the cacheField and pivotCache elements.

Excel requires that the value of the serverField attribute on the cacheField element be 1 and the value of the type attribute on the associated pivotCache element be external when the value of the serverField attribute on this element is true.

fff. The standard does not mention that if autoShow is true, there are range limitations on itemPageCount.

In Excel, the itemPageCount attribute must be between 1 and 255 inclusive or the rankBy attribute must be greater than or equal to 0 and less than the number of dataField elements.

ggg. The standard does not specify restrictions for the hideNewItems attribute.

Office specifies that the hideNewItems attribute shall be false for non-OLAP pivotTables.

hhh. The standard does not specify restrictions for the showPropAsCaption attribute.

Office specifies that the showPropAsCaption attribute shall be false for non-OLAP pivotTables.

iii. The standard does not specify restrictions for the showPropCell attribute.

Office specifies that the showPropCell attribute shall be false for non-OLAP tables.

jjj. The standard does not specify restrictions for the showPropTip attribute.

Office specifies that the showPropTip attribute shall be false for non-OLAP pivotTables.

kkk. The standard does not specify restrictions for the showAll attribute.

Office specifies that the showAll attribute shall be false for OLAP pivotTables.

lll. The standard does not specify restrictions on @dataSourceSort.

Office specifies that @dataSourceSort shall not be 1 on a non-OLAP PivotTable.

mmm. The standard describes @hiddenLevel as a PivotTable wide attribute.

Office assumes @hiddenLevel refers to the particular level of this PivotField.

nnn. The standard specifies that a @dataField value of 0 or false indicates this field appears in another region of the PivotTable.

Office assumes a @dataField value of 0 or false indicates this field does not appear in the data region of the PivotTable.

ooo. The standard states that @itemPageCount is the number of items showed per page in the PivotTable.

In Office, specifies @itemPageCount is the number of items to show when the PivotTable’s Autoshow feature is enabled.

ppp. The standard specifies the subtotalCaption attribute as text.

Office will replace the ? character in this attribute with the field name when displayed in the UI.

qqq. The standard states that a value of 0 or false for @serverField indicates that this is a local page field.

In Office, assumes value of 0 or false indicates that this is not a server-based page field and the @axis can be any valid value.

rrr. The standard does not state when @dragToData is used.

Office ignores @dragToData for OLAP PivotTables.

sss. The standard does not state when @dragToRow is used.

Office ignores @dragToRow for OLAP PivotTables.

ttt. The standard does not state when @dragToCol is used.

Office ignores @dragToCol for OLAP PivotTables.

uuu. The standard does state when @dragToPage will be used.

In Office, @dragToPage is ignored for OLAP PivotTables.

vvv. The standard does not require a corresponding item element when the avgSubtotal is true.

In Office, if avgSubtotal is true, then this element's items collection must contain an item element with t="avg".

www. The standard does not require a corresponding item element when the countASubtotal is true.

In Office, if countASubtotal is true, then this element's items collection must contain an item element with t="countA".

xxx. The standard does not require a corresponding item element when @countSubtotal is true.

In Office if @countSubtotal is true, then this element's items collection must contain an item element with t="count".

yyy. The standard does not require a corresponding item element when the maxSubtotal is true.

In Office, if maxSubtotal is true, then this element's items collection must contain an item element with t="max".

zzz. The standard does not require a corresponding item element when the minSubtotal is true.

In Office, if minSubtotal is true, then this element's items collection must contain an item element with t="min".

aaaa. The standard does not require a corresponding item element when the productSubtotal is true.

In Office, if productSubtotal is true, then this element's items collection must contain an item element with t="product".

bbbb. The standard does not require a corresponding item element when the stdDevPSubtotal is true.

In Office, if stdDevPSubtotal is true, then this element's items collection must contain an item element with t="stdDevP".

cccc. The standard does not require a corresponding item element when the stdDevSubtotal is true.

In Office, if stdDevSubtotal is true, then this element's items collection must contain an item element with t="stdDev".

dddd. The standard does not require a corresponding item element when the sumSubtotal is true.

In Office, if sumSubtotal is true, then this element's items collection must contain an item element with t="sum".

eeee. The standard does not require a corresponding item element when the varPSubtotal is true.

In Office, if varPSubtotal is true, then this element's items collection must contain an item element with t="varP".

ffff. The standard does not require a corresponding item element when the varSubtotal is true.

In Office, if varSubtotal is true, then this element's items collection must contain an item element with t="var".

gggg. The standard does not require a corresponding item element when the defaultSubtotal is false.

In Office, if defaultSubtotal is true or not written, then this element's items collection must contain an item element with t="default".

hhhh. The standard does not state any requirements on the type of PivotTable for which @uniqueMemberProperty is valid.

Office requires that this attribute is only set on OLAP PivotTables.

iiii. The standard does not restrict the usage of the includeNewItemsInFilter attribute.

Office assumes the includeNewItemsInFilter attribute shall be ignored for OLAP PivotTables.

jjjj. The standard states that @showPropTip determines if a tooltip is shown for a PivotTable cell.

In Office the value of mp@showTip, if present, takes precedence over @showPropTip.

kkkk. The standard states that @showPropCell determines if a tooltip is shown for a PivotTable cell.

In Office the value of mp@showCell, if present, takes precedence over @showPropCell.

Show:
© 2014 Microsoft