source/text/scalc/02/06030000.xhp | 46 ++++++++++++++++++++++++++++++--------
1 file changed, 37 insertions(+), 9 deletions(-)
New commits:
commit edd797863d4a748784ba72c5148c434e8c5977dd
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jun 20 19:11:07 2020 -0300
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
