diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/consolidate.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/consolidate.xhp | 143 |
1 files changed, 70 insertions, 73 deletions
diff --git a/helpcontent2/source/text/scalc/guide/consolidate.xhp b/helpcontent2/source/text/scalc/guide/consolidate.xhp index 7733ad2d06..8e73e02e12 100755 --- a/helpcontent2/source/text/scalc/guide/consolidate.xhp +++ b/helpcontent2/source/text/scalc/guide/consolidate.xhp @@ -1,19 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * - * Copyright 2008 by Sun Microsystems, Inc. + * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: consolidate.xhp,v $ - * $Revision: 1.8 $ - * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify @@ -33,71 +29,72 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguideconsolidatexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Consolidating Data</title> -<filename>/text/scalc/guide/consolidate.xhp</filename> -</topic> -</meta> -<body> + <topic id="textscalcguideconsolidatexml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Consolidating Data</title> + <filename>/text/scalc/guide/consolidate.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>consolidating data</bookmark_value> -<bookmark_value>ranges; combining</bookmark_value> -<bookmark_value>combining;cell ranges</bookmark_value> -<bookmark_value>tables; combining</bookmark_value> -<bookmark_value>data; merging cell ranges</bookmark_value> -<bookmark_value>merging;data ranges</bookmark_value> -</bookmark><comment>mw deleted "values;"</comment><paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="1" l10n="U" oldref="5"><variable id="consolidate"><link href="text/scalc/guide/consolidate.xhp" name="Consolidating Data">Consolidating Data</link> + <bookmark_value>ranges; combining</bookmark_value> + <bookmark_value>combining;cell ranges</bookmark_value> + <bookmark_value>tables; combining</bookmark_value> + <bookmark_value>data; merging cell ranges</bookmark_value> + <bookmark_value>merging;data ranges</bookmark_value> +</bookmark><comment>mw deleted "values;"</comment> +<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> </variable></paragraph> -<paragraph role="paragraph" id="par_id3153191" xml-lang="en-US" l10n="U" oldref="34">During consolidation, the contents of the cells from several sheets will be combined in one place.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US" l10n="U" oldref="6">Open the document that contains the cell ranges to be consolidated.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3154513" xml-lang="en-US" l10n="U" oldref="7">Choose <item type="menuitem">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3147345" xml-lang="en-US" l10n="U" oldref="8">From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas.</paragraph> -<paragraph role="paragraph" id="par_id3149209" xml-lang="en-US" 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> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3155529" xml-lang="en-US" l10n="U" oldref="10">Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3153816" xml-lang="en-US" l10n="U" oldref="11">Select additional ranges and click <emph>Add</emph> after each selection.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3157983" xml-lang="en-US" 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> -<paragraph role="paragraph" id="par_id3150215" xml-lang="en-US" 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> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3153813" xml-lang="en-US" 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> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3149315" xml-lang="en-US" l10n="U" oldref="15">Click <emph>OK</emph> to consolidate the ranges.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="par_idN107DE" xml-lang="en-US" level="2" l10n="NEW">Additional Settings</paragraph> -<paragraph role="paragraph" id="par_id3147250" xml-lang="en-US" l10n="U" oldref="16">Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="listitem" id="par_id3156400" xml-lang="en-US" 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> -<paragraph role="listitem" id="par_id3150538" xml-lang="en-US" 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> -</listitem> -</list> -<list type="unordered"> -<listitem> -<paragraph role="listitem" id="par_id3149945" xml-lang="en-US" 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> -<paragraph role="listitem" id="par_id3157871" xml-lang="en-US" l10n="U" oldref="20">To consolidate by row labels or column labels, the label must be contained in the selected source ranges.</paragraph> -<paragraph role="note" id="par_id3150478" xml-lang="en-US" 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> -</listitem> -</list> -<paragraph role="paragraph" id="par_id3147468" xml-lang="en-US" 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> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3153039" xml-lang="en-US" l10n="U" oldref="33"><link href="text/scalc/01/12070000.xhp" name="Data - Consolidate">Data - Consolidate</link></paragraph> -</section> -</body> -</helpdocument> + <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> + <paragraph xml-lang="en-US" id="hd_id892056" role="heading" level="2" l10n="NEW">To Combine Cell Contents</paragraph> + <list type="ordered"> + <listitem> + <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> + </listitem> + <listitem> + <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> + </listitem> + <listitem> + <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> + <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> + </listitem> + <listitem> + <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> + </listitem> + <listitem> + <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> + </listitem> + <listitem> + <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> + <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> + </listitem> + <listitem> + <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> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149315" role="listitem" l10n="U" oldref="15">Click <emph>OK</emph> to consolidate the ranges.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_idN107DE" role="heading" level="2" l10n="NEW">Additional Settings</paragraph> + <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> + <list type="unordered"> + <listitem> + <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> + <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> + </listitem> + </list> + <list type="unordered"> + <listitem> + <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> + <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> + <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> + </listitem> + </list> + <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> + <section id="relatedtopics"> + <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> + </section> + </body> +</helpdocument>
\ No newline at end of file |