[Libreoffice-commits] help.git: source/text

Olivier Hallot (via logerrit) logerrit at kemper.freedesktop.org
Thu Jun 25 13:05:17 UTC 2020


 source/text/scalc/02/06030000.xhp |   46 ++++++++++++++++++++++++++++++--------
 1 file changed, 37 insertions(+), 9 deletions(-)

New commits:
commit edd797863d4a748784ba72c5148c434e8c5977dd
Author:     Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Sat Jun 20 19:11:07 2020 -0300
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Thu Jun 25 15:04:56 2020 +0200

    tdf#132464 Enhance Help for sumation icon
    
    Change-Id: Iec55f78002beb2052e0d49089f1b3a09171fa43f
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96784
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/02/06030000.xhp b/source/text/scalc/02/06030000.xhp
index e648f3359..aab5645aa 100644
--- a/source/text/scalc/02/06030000.xhp
+++ b/source/text/scalc/02/06030000.xhp
@@ -34,25 +34,53 @@
          <bookmark_value>AutoSum button, see sum icon</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/><comment>MW inserted a cross-reference</comment>
-<paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph>
-         <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph"><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>
+<h1 id="hd_id3157909"><link href="text/scalc/02/06030000.xhp" name="Sum">Select Function</link></h1>
+         <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph"><ahelp hid="HID_INSWIN_SUMME">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp></paragraph>
       </section>
       <section id="sysumme">
          <table id="tbl_id3150868">
             <tablerow>
                <tablecell>
                   <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph">
-<image id="img_id3147434" src="cmd/sc_autosum.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt>
+<image id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3147434">Icon Select Function</alt>
 	</image></paragraph>
                </tablecell>
                <tablecell>
-                  <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph">Sum</paragraph>
+                  <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph">Select Function</paragraph>
                </tablecell>
             </tablerow>
          </table>
-
-      </section>
-      <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph">$[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>
-      <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph>
+</section>        
+<h2 id="hd_id161592658402954">Select Function applied with no selected range</h2> 
+<paragraph xml-lang="en-US" id="par_id3156444" role="paragraph">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph">Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>.</paragraph>
+<table id="tab_id891592663499228">
+    <tablerow>
+        <tablecell>
+            <paragraph role="image" id="par_id231592663499228">
+<image src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm" height="1cm"><alt id="alt_id171592663499228">Accept Icon</alt></image>
+            </paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id481592663499228" role="paragraph">Accept</paragraph>
+       </tablecell>
+    </tablerow>
+</table>    
+<table id="tab_id591592663828848">
+    <tablerow>
+        <tablecell>
+            <paragraph role="image" id="par_id311592663828848">
+<image src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm" height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image>
+            </paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id431592663828848" role="paragraph">Cancel</paragraph>
+       </tablecell>
+    </tablerow>
+</table>
+     
+<h2 id="hd_id261592658395518">Select Function applied on a selected range</h2>     
+<paragraph role="paragraph" id="par_id911592658130888">When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column.</paragraph>
+<paragraph role="paragraph" id="par_id991592658144387">When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.</paragraph>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>


More information about the Libreoffice-commits mailing list