source/text/scalc/01/04060106.xhp | 24 +++---------------------
1 file changed, 3 insertions(+), 21 deletions(-)
New commits:
commit 99120cbfb9b5c0c75bc1b3317fa87ecab58d170a
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Wed Nov 10 13:14:38 2021 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 10 13:22:08 2021 +0100
Update help page for Calc's Mathematical Functions to remove detail about
SUM() function.
Leave just a link and a one line overview. This is a follow-up to change
https://gerrit.libreoffice.org/c/help/+/124696.
Change-Id: I31898c9f8d1fc0dca83a7d3fc12d466a3d50928c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124865
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index a245b9d28..c04614745 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1017,27 +1017,9 @@
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
-<section id="Section16">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3163596">
- <bookmark_value>SUM function</bookmark_value>
- <bookmark_value>adding;numbers in cell ranges</bookmark_value>
-</bookmark>
-<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608"
localize="false"/>
-
-<h2 id="hd_id3163596"><variable id="sum_head"><link
href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></h2>
-<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SUMME">Adds a set of numbers.</ahelp></paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
-<embed href="text/scalc/01/ful_func.xhp#number255"/>
-<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3163704" role="paragraph"
xml-lang="en-US"><input>=SUM(2;3;4)</input> returns 9.</paragraph>
-<paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item
type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three
cells.</paragraph>
-<paragraph id="par_id931636109030406" role="paragraph" xml-lang="en-US"><item
type="input">=SUM(A1:E10)</item> calculates the sum of all cells in the A1 to
E10 cell range.</paragraph>
-<paragraph id="par_id3151756" role="paragraph" xml-lang="en-US">A formula such
as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as
an <link href="text/scalc/01/04060107.html#hd_id3148474"
name="ARRAY_FORMULA">array formula</link> by pressing the Shift<switchinline
select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter
keys instead of simply pressing the Enter key to finish entering the formula.
The formula will then be shown in the Formula bar enclosed in braces and
operates by multiplying corresponding elements of the arrays together and
returning their sum.</paragraph>
-<tip id="par_id661636108218550">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM";
name="SUM_Wiki">SUM</link> wiki page for more details about this function.</tip>
+<section id="sum">
+ <h2 localize="false" id="hd_id841636542200276"><embedvar
href="text/scalc/01/func_sum.xhp#sum_head"/></h2>
+ <paragraph id="par_id301636542246396" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_sum.xhp#func_sum_desc"/></paragraph>
</section>
<section id="Section15">
