source/text/scalc/01/04060106.xhp | 5 +++--
source/text/scalc/01/04060184.xhp | 3 +--
2 files changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 11e69d34205bf773f2aa4f4be5c8fa08566ed7d7
Author: Seth Chaiklin <sdc.bla...@youmail.dk>
AuthorDate: Wed Nov 11 13:47:29 2020 +0200
Commit: Seth Chaiklin <sdc.bla...@youmail.dk>
CommitDate: Sat Mar 27 09:33:08 2021 +0100
tdf#137715 add "note" to AVERAGE, SUMSQ, PRODUCT in Calc function help
( scalc/01/04060106.xhp )
+ add two variables "ignores" and "look" to <tip> in SUM
+ use two new variables to compose similar tip for
"PRODUCT" and "SUMSQ"
( scalc/01/04060184.xhp )
+ use two new variables to compose similar tip for AVERAGE
Change-Id: Id6fd2f38a3f3d7c381b3efe99a98303a81e0c1d6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105535
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
Reviewed-by: Seth Chaiklin <sdc.bla...@youmail.dk>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 46f21ba8a..27c795e16 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -777,6 +777,7 @@
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3144494" role="paragraph" xml-lang="en-US"><item
type="input">=PRODUCT(2;3;4)</item> returns 24.</paragraph><comment>see also
FACT, SUM</comment>
+<tip id="par_id3116050958783013">PRODUCT <embedvar
href="text/scalc/01/04060106.xhp#ignores"/> PRODUCT <embedvar
href="text/scalc/01/04060106.xhp#look"/></tip>
</section>
<section id="Section25">
@@ -795,6 +796,7 @@
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3160449" role="paragraph" xml-lang="en-US">If you enter
the numbers 2; 3 and 4 in the Number 1; 2 and 3 arguments, 29 is returned as
the result.</paragraph>
+<tip id="par_id311605095861133">SUMSQ <embedvar
href="text/scalc/01/04060106.xhp#ignores"/> SUMSQ <embedvar
href="text/scalc/01/04060106.xhp#look"/></tip>
</section>
<section id="Section24">
@@ -1023,7 +1025,7 @@
<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"/>
-<tip id="par_id151567608802604">SUM ignores any text or empty cell within a
range or array. If you suspect wrong results of the SUM function, look for text
in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value
highlight">value highlighting</link> feature to highlight the text contents in
the range that may represent a number.</tip>
+<tip id="par_id151567608802604">SUM <variable id="ignores">ignores any text or
empty cell within a range or array. If you suspect wrong results of
the</variable> SUM <variable id="look">function, look for text in the data
ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value
highlight">value highlighting</link> feature to highlight the text contents in
the range that may represent a number.</variable></tip>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter
the numbers <item type="input">2</item>; <item type="input">3 </item>and <item
type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned
as the result.</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. <item
type="input">=SUM (A1:E10)</item> calculates the sum of all cells in the A1 to
E10 cell range.</paragraph>
@@ -1587,5 +1589,4 @@
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index 4cc4f0ec5..31494293a 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,7 +18,6 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc0104060184xml" indexer="include">
<title xml-lang="en-US" id="tit">Statistical Functions Part Four</title>
@@ -131,6 +129,7 @@
<paragraph xml-lang="en-US" id="par_id3151232" role="paragraph">
<item type="input">=AVERAGE(A1:A50)</item>
</paragraph>
+<tip id="par_id311605095862433">AVERAGE <embedvar
href="text/scalc/01/04060106.xhp#ignores"/> AVERAGE <embedvar
href="text/scalc/01/04060106.xhp#look"/></tip>
</section>
<section id="averagea">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148754"><bookmark_value>AVERAGEA function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
