2.1.787 Part 1 Section 18.10.1.73, pivotTableDefinition (PivotTable Definition)

  • Article

For additional notes that apply to this portion of the standard, please see the notes for raf, §18.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 does not define a default value for @autoFormatId.

Office defines a default value for @autoFormatId of 1.

c.   The standard describes the mdxSubqueries attribute.

Office does not use the mdxSubqueries attribute.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

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

Office has a maximum value of 127 for @indent.

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

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

Office allows a max value of 255 for @pageWrap.

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

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

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

Office only uses @showEmptyRow for OLAP PivotTables.

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

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

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