From 574314d641fcad0b07451f893becf616ed681e2c Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@libreoffice.org>
Date: Sat, 20 Jun 2020 19:11:07 -0300
Subject: 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@libreoffice.org>
(cherry picked from commit 93de72b7c394831e52794e4d37905fd424d51722)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97133
---
 source/text/scalc/02/06030000.xhp | 46 +++++++++++++++++++++++++++++++--------
 1 file changed, 37 insertions(+), 9 deletions(-)

(limited to 'source')

diff --git a/source/text/scalc/02/06030000.xhp b/source/text/scalc/02/06030000.xhp
index e648f3359e..aab5645aaa 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>
-- 
cgit