source/text/scalc/01/04060106.xhp | 5 ++---
source/text/scalc/01/04060184.xhp | 3 ++-
2 files changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 938d18980a672859c4e9b754df10bf18fa6b1cd4
Author: Seth Chaiklin <sdc.bla...@youmail.dk>
AuthorDate: Sat Mar 27 15:42:54 2021 +0100
Commit: Seth Chaiklin <sdc.bla...@youmail.dk>
CommitDate: Sat Mar 27 16:26:30 2021 +0100
Revert "tdf#137715 add "note" to AVERAGE, SUMSQ, PRODUCT in Calc function
help"
This reverts commit 11e69d34205bf773f2aa4f4be5c8fa08566ed7d7.
Reason for revert: A new, better solution is found for adding a
note to these functions that avoids retranslation and avoids technical
problems with <embedvar>. That solution will be used in a new patch
for these functions.
Change-Id: I614eb2020b77715b5785ad3a2934cc359f0b8ef9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113214
Tested-by: Jenkins
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 27c795e16..46f21ba8a 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -777,7 +777,6 @@
<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">
@@ -796,7 +795,6 @@
<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">
@@ -1025,7 +1023,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 <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>
+<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>
<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>
@@ -1589,4 +1587,5 @@
<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 31494293a..4cc4f0ec5 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -1,5 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,6 +19,7 @@
* 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>
@@ -129,7 +131,6 @@
<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
