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>

end example]

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>