Attributes on pivotTableDefinition
<pivotTableDefinition xmlns:sh="…" name="PivotTable2" cacheId="5" applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="0" applyPatternFormats="0" applyAlignmentFormats="0" applyWidthHeightFormats="1" dataCaption="Values" updatedVersion="3" minRefreshableVersion="3" showCalcMbrs="0" useAutoFormatting="1" colGrandTotals="0" itemPrintTitles="1" createdVersion="3" indent="0" outline="1" outlineData="1" multipleFieldFilters="0">
In the context of <pivotTableDefinition>
:
@name
indicates the name of the PivotTable.@cacheId
references by Id a particular pivotCache in the<pivotCaches>
collection listed in workbook.xml.@applyNumberFormats
value of "1
" means to apply legacy autoformat number format properties.@applyBorderFormats
value of "1
" means to apply legacy autoformat border format properties.@applyFontFormats
value of "1
" means to apply legacy autoformat Font format properties.@applyPatternFormats
value of "1
" means to apply legacy autoformat pattern format properties.@applyAlignmentFormats
value of "1
" means to apply legacy autoformat alignment format properties.@applyWidthHeightFormats
value of "1
" means to apply legacy autoformat width and height format properties.@dataCaption
is the name of the values area header cell which can appear in the PivotTable when two or more fields are in the values area.@updatedVersion
is the Pivot version that last updated the PivotTable.@minRefreshableVersion
is the minimum Pivot version required to update this PivotTable's Pivot Cache.@showCalcMbrs
indicates whether calculated members should be shown in the PivotTable. Only applies to PivotTables based on OLAP sources.@useAutoFormatting
indicates whether autoformatting has been applied to the PivotTable.@colGrandTotals
indicates whether column grand totals are on for this PivotTable.@rowGrandTotals
defaults to "1
" and therefore is not written.@itemPrintTitles
flag indicating whether PivotItem names should be repeated at the top of each printed page.@createdVersion
The Pivot version that created the cache.@indent
indentation increment for compact row axis, which means the Report Layout is set to Compact Form.@outline
flag indicating whether new fields should have their outline form flag set to "1
".@outlineData
flag indicating whether the values field in the PivotTable should be displayed in outline form.@multipleFieldFilters
flag indicating whether each field of a pivot table can have multiple filters set on it.