[Libreoffice-commits] help.git: source/text

[Seth Chaiklin (via logerrit)]

 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.blanco at youmail.dk>
AuthorDate: Wed Nov 11 13:47:29 2020 +0200
Commit:     Seth Chaiklin <sdc.blanco at 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.kaganski at collabora.com>
    Reviewed-by: Seth Chaiklin <sdc.blanco at 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>