Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

2.1.814 Part 4 Section 3.10.1.73, pivotTableDefinition (PivotTable Definition)

For additional notes that apply to this portion of the standard, please see the notes for raf, §3.11.1.8(b) .

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

Excel uses a default value of 0 for this attribute.

b. The standard states that on and off are valid values of the asteriskTotals 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 define a default value for @autoFormatId.

Office defines a default value for @autoFormatId of 1.

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

Excel does not allow these values on this attribute.

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

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

f. The standard states that on and off are valid values of the customListSort attribute.

Excel does not allow these values on this attribute.

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

g. The standard states that on and off are valid values of the dataOnRows 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 disableFieldList 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 editData 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 enableDrill 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 enableFieldProperties 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 enableWizard 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 fieldListSortAscending 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 fieldPrintTitles 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 gridDropZones 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 immersive 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 itemPrintTitles 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 describes the mdxSubqueries attribute.

Office does not use the mdxSubqueries attribute.

s. The standard states that on and off are valid values of the mergeItem 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 multipleFieldFilters 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 outline 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 outlineData 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 pageOverThenDown 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 preserveFormatting 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 printDrill 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 published 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 rowGrandTotals 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 showCalcMbrs 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 showDataDropDown 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 showDataTips 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 showDrill 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 showDropZones 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 showEmptyCol 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 showEmptyRow 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 showError 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 showHeaders 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 showItems 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 showMemberPropertyTips 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 showMissing 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 showMultipleLabel 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 subtotalHiddenItems 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 useAutoFormatting 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 visualTotals 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 for @asteriskTotals that 1 or true means that asterisks will be displayed.

In Office, a value for @asteriskTotals of 1 or true means that asterisks will not be displayed.

ss. The standard does not limit the length of the value of the dataCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters.

tt. The standard does not limit the length of the value of the grandTotalCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters.

uu. The standard does not limit the length of the value of the errorCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters.

vv. The standard does not limit the length of the value of the missingCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters.

ww. The standard does not limit the length of the value of the pageStyle attribute.

Excel restricts the value of this attribute to be at most 255 characters.

xx. The standard does not limit the length of the value of the pivotTableStyle attribute.

Excel restricts the value of this attribute to be at most 255 characters.

yy. The standard does not limit the length of the value of the vacatedStyle attribute.

Excel restricts the value of this attribute to be at most 255 characters.

zz. The standard does not limit the length of the value of the tag attribute.

Excel restricts the value of this attribute to be at most 255 characters.

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

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

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

ccc. The standard says that, for @preserveFormatting, 1 or true specifies to discard formatting on refresh.

Office interprets a value of 1 or true for @preserveFormatting to indicate the formatting will be preserved and 0 or false to indicate the formatting will be discarded.

ddd. The standard's @subtotalHiddenItems definition refers to the data area of the pivotTable.

Office defines @subtotalHiddenItems to indicate whether hidden items in the page area of the pivotTable are used for subtotal calculation.

eee. The standard says that a value of 1 for @immersive means immersive is off, and that 0 means it's on.

Office specifies a value of 1 for @immersive means that the immersive experience is left on, and a value of 0 means it's turned off.

fff. The standard does not explain what the published attribute is used for.

Office uses the published attribute to indicate that the PivotTable is published for display in a Web browser.

ggg. The standard does not list valid values for the autoFormatId attribute.

Office, in the context of pivotTableDefinition, requires that the value of the autoFormatId attribute be less than 21 or greater than 4096 and less than or equal to 4117.

hhh. The standard does not state a default value for the applyNumberFormats attribute.

Excel uses a default value of 0 for this attribute.

iii. The standard does not state a default value for the applyBorderFormats attribute.

Excel uses a default value of 0 for this attribute.

jjj. The standard does not state a default value for the applyFontFormats attribute.

Excel uses a default value of 0 for this attribute.

kkk. The standard does not state a default value for the applyPatternFormats attribute.

Excel uses a default value of 0 for this attribute.

lll. The standard does not state a default value for the applyAlignmentFormats attribute.

Excel uses a default value of 0 for this attribute.

mmm. The standard does not state a default value for the applyWidthHeightFormats attribute.

Excel uses a default value of 0 for this attribute.

nnn. The standard does not limit the length of the value of the colHeaderCaption attribute.

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

ooo. The standard does not state a maximum value for @indent.

Office has a maximum value of 127 for @indent.

ppp. The standard does not state how to interpret the values for @indent, or the value for no indent.

Office assumes that @indent contains a number that is one less than the number of indent increments to apply; greater than or equal to zero and less than or equal to 127. A value of 127 indicates no indent will be used.

qqq. The standard does not specify a maximum value for @pageWrap.

Office allows a max value of 255 for @pageWrap.

rrr. The standard does not define a default value for @rowHeaderCaption.

Office assumes that if @rowHeaderCaption is not present an application specific string can be used.

sss. The standard specifies the showEmptyCol attribute as indicating whether to include empty columns in the table.

Office only uses the showEmptyCol attribute for OLAP PivotTables.

ttt. The standard specifies @showEmptyRow as indicating whether to include empty rows in the table.

Office only uses @showEmptyRow for OLAP PivotTables.

uuu. The standard does not define when @subtotalHiddenItems should be used by an application.

Office only uses the value of @subtotalHiddenItems for non-OLAP PivotTables.

vvv. The standard states that page fields allow filtering of the entire PivotTable report to display data for a single item or all of the items.

In Office, page fields allow filtering to display data for multiple items.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.