helpcontent2/source/text/scalc/02/06030000.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: 06030000.xhp,v $
  15  * $Revision: 1.7 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textscalc0206030000xml" indexer="include" status="PUBLISH">
  41 <title xml-lang="en-US" id="tit">Sum</title>
  42 <filename>/text/scalc/02/06030000.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46
  47
  48   <section id="summe">
  49
  50
  51 <bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>functions;sum function icon</bookmark_value>
  52 <bookmark_value>formula bar;sum function</bookmark_value>
  53 <bookmark_value>sum icon</bookmark_value>
  54 </bookmark>
  55
  56 <bookmark xml-lang="en-US" branch="hid/HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/>
  57    <comment>mw deleted "sum function..."</comment>
  58    <paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph>
  59    <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp></paragraph>
  60
  61   </section>
  62   <section id="sysumme">
  63
  64    <table id="tbl_id3150868">
  65
  66
  67     <tablerow>
  68      <tablecell>
  69       <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph" l10n="E">
  70 <image id="img_id3147434" src="res/commandimagelist/sc_autosum.png" width="0.222inch" height="0.222inch"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt>
  71         </image></paragraph>
  72      </tablecell>
  73      <tablecell>
  74       <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="15">Sum</paragraph>
  75      </tablecell>
  76     </tablerow>
  77    </table>
  78
  79   </section>
  80   <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph>
  81   <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph>
  82  </body>
  83 </helpdocument>