Consolidation class
Defines the Consolidation Class. When the object is serialized out as xml, its qualified name is x:consolidation.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.Consolidation
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
[ISO/IEC 29500-1 1st Edition]
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]
Parent Elements |
|---|
cacheSource (§18.10.1.7) |
Child Elements | Subclause |
|---|---|
pages (Page Item Values) | §18.10.1.65 |
rangeSets (Range Sets) | §18.10.1.80 |
Attributes | Description |
|---|---|
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.