1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textscalcguideconsolidatexml" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">Consolidating Data</title> 31*b1cdbd2cSJim Jagielski <filename>/text/scalc/guide/consolidate.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>consolidating data</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>ranges; combining</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>combining;cell ranges</bookmark_value> 38*b1cdbd2cSJim Jagielski <bookmark_value>tables; combining</bookmark_value> 39*b1cdbd2cSJim Jagielski <bookmark_value>data; merging cell ranges</bookmark_value> 40*b1cdbd2cSJim Jagielski <bookmark_value>merging;data ranges</bookmark_value> 41*b1cdbd2cSJim Jagielski</bookmark><comment>mw deleted "values;"</comment> 42*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1" l10n="U" oldref="5"><variable id="consolidate"><link href="text/scalc/guide/consolidate.xhp" name="Consolidating Data">Consolidating Data</link> 43*b1cdbd2cSJim Jagielski</variable></paragraph> 44*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153191" role="paragraph" l10n="U" oldref="34">During consolidation, the contents of the cells from several sheets will be combined in one place.</paragraph> 45*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id892056" role="heading" level="2" l10n="NEW">To Combine Cell Contents</paragraph> 46*b1cdbd2cSJim Jagielski <list type="ordered"> 47*b1cdbd2cSJim Jagielski <listitem> 48*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151073" role="listitem" l10n="U" oldref="6">Open the document that contains the cell ranges to be consolidated.</paragraph> 49*b1cdbd2cSJim Jagielski </listitem> 50*b1cdbd2cSJim Jagielski <listitem> 51*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154513" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog.</paragraph> 52*b1cdbd2cSJim Jagielski </listitem> 53*b1cdbd2cSJim Jagielski <listitem> 54*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147345" role="listitem" l10n="U" oldref="8">From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas.</paragraph> 55*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149209" role="listitem" l10n="U" oldref="9">If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse.</paragraph> 56*b1cdbd2cSJim Jagielski </listitem> 57*b1cdbd2cSJim Jagielski <listitem> 58*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="10">Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field.</paragraph> 59*b1cdbd2cSJim Jagielski </listitem> 60*b1cdbd2cSJim Jagielski <listitem> 61*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153816" role="listitem" l10n="U" oldref="11">Select additional ranges and click <emph>Add</emph> after each selection.</paragraph> 62*b1cdbd2cSJim Jagielski </listitem> 63*b1cdbd2cSJim Jagielski <listitem> 64*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157983" role="listitem" l10n="U" oldref="12">Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box.</paragraph> 65*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150215" role="listitem" l10n="U" oldref="13">If the target range is not named, click in the field next to <emph>Copy results to</emph> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range.</paragraph> 66*b1cdbd2cSJim Jagielski </listitem> 67*b1cdbd2cSJim Jagielski <listitem> 68*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153813" role="listitem" l10n="U" oldref="14">Select a function from the <emph>Function</emph> box. The function specifies how the values of the consolidation ranges are linked. The "Sum" function is the default setting.</paragraph> 69*b1cdbd2cSJim Jagielski </listitem> 70*b1cdbd2cSJim Jagielski <listitem> 71*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149315" role="listitem" l10n="U" oldref="15">Click <emph>OK</emph> to consolidate the ranges.</paragraph> 72*b1cdbd2cSJim Jagielski </listitem> 73*b1cdbd2cSJim Jagielski </list> 74*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_idN107DE" role="heading" level="2" l10n="NEW">Additional Settings</paragraph> 75*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147250" role="paragraph" l10n="U" oldref="16">Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:</paragraph> 76*b1cdbd2cSJim Jagielski <list type="unordered"> 77*b1cdbd2cSJim Jagielski <listitem> 78*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156400" role="listitem" l10n="U" oldref="17">Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range.</paragraph> 79*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150538" role="listitem" l10n="U" oldref="18">The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.</paragraph> 80*b1cdbd2cSJim Jagielski </listitem> 81*b1cdbd2cSJim Jagielski </list> 82*b1cdbd2cSJim Jagielski <list type="unordered"> 83*b1cdbd2cSJim Jagielski <listitem> 84*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149945" role="listitem" l10n="U" oldref="19">Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label.</paragraph> 85*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157871" role="listitem" l10n="U" oldref="20">To consolidate by row labels or column labels, the label must be contained in the selected source ranges.</paragraph> 86*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150478" role="note" l10n="U" oldref="21">The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.</paragraph> 87*b1cdbd2cSJim Jagielski </listitem> 88*b1cdbd2cSJim Jagielski </list> 89*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147468" role="paragraph" l10n="U" oldref="22">The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available.</paragraph> 90*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 91*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153039" role="paragraph" l10n="U" oldref="33"><link href="text/scalc/01/12070000.xhp" name="Data - Consolidate">Data - Consolidate</link></paragraph> 92*b1cdbd2cSJim Jagielski </section> 93*b1cdbd2cSJim Jagielski </body> 94*b1cdbd2cSJim Jagielski</helpdocument>