<dataConsolidate> (Data Consolidate)

Data consolidation settings. The dataRefs are the set of source ranges containing data to consolidate. The function indicates the function that shall be used to consolidate the data.

example:

This example demonstrates consolidating the ranges A1:C1 and A3:C3 by using the 'count' function.

<dataConsolidate function="count">
  <dataRefs count="2">
    <dataRef ref="A1:C1" sheet="Sheet1"/>
    <dataRef ref="A3:C3" sheet="Sheet1"/>
  </dataRefs>
</dataConsolidate>

Parent Elements

<worksheet> (§3.3.1.96)

Child Elements

Subclause

<dataRefs> (Data Consolidation References)

§3.3.1.29

Attributes

Description

<function> (Function Index)

Indicates which function to use when consolidating the ranges.

The possible values for this attribute are defined by the ST_DataConsolidateFunction simple type (§3.18.18).

<leftLabels> (Use Left Column Labels)

Use labels in left column. Both @leftLabels and @topLabels can be true at the same time.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<link> (Link)

Create links to source data.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<topLabels> (Labels In Top Row)

Use labels in top row. Both @leftLabels and @topLabels can be true at the same time.

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_DataConsolidate">
	<sequence>
	<element name="dataRefs" type="CT_DataRefs" minOccurs="0" maxOccurs="1"/>
	</sequence>
	<attribute name="function" type="ST_DataConsolidateFunction" use="optional" default="sum"/>
	<attribute name="leftLabels" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="topLabels" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="link" type="xsd:boolean" use="optional" default="false"/>
</complexType>