Defines the Consolidation Class.When the object is serialized out as xml, its qualified name is x:consolidation.
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
The following table lists the possible child types:
[ISO/IEC 29500-1 1st Edition]
220.127.116.11 consolidation (Consolidation Source)
Represents the description of the PivotCache source using multiple consolidation ranges. This element is used when the source of the PivotTable is a collection of ranges in the workbook. The ranges are specified in the rangeSets collection. The logic for how the application consolidates the data in the ranges is application-defined. [Example: the application might consolidate data based on its position in the worksheet that the end-user specifies. end example]
pages (Page Item Values)
rangeSets (Range Sets)
autoPage (Auto Page)
Specifies a boolean value that indicates whether the application will automatically create one additional page field to describe/qualify the source ranges.
A value of 1 or true indicates the application will create an additional page field.
A value of 0 or false indicates will not create an additional page field.
The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
[Note: The W3C XML Schema definition of this element’s content model (CT_Consolidation) is located in §A.2. end note]
© ISO/IEC29500: 2008.