Consolidation Class

Office 2010

Defines the Consolidation Class.When the object is serialized out as xml, its qualified name is x:consolidation.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[ChildElementInfoAttribute(typeof(RangeSets))]
[ChildElementInfoAttribute(typeof(Pages))]
public class Consolidation : OpenXmlCompositeElement

The following table lists the possible child types:

  • Pages <x:pages>

  • RangeSets <x:rangeSets>


[ISO/IEC 29500-1 1st Edition]

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft