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

[Eike Rathke (via logerrit)]

 source/text/scalc/guide/numbers_text.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 34b0364e6289a299fb0b50b5b0d487e37f6e9492
Author:     Eike Rathke <erack at redhat.com>
AuthorDate: Tue Feb 4 14:59:03 2020 +0100
Commit:     Eike Rathke <erack at redhat.com>
CommitDate: Tue Feb 4 15:19:24 2020 +0100

    Correct string "has value 0" to "is ignored" for the SUM function
    
    Which doesn't exactly matter for SUM but would for AVERAGE, for
    example.
    
    Change-Id: If2d416123890349f4458ca10274e3fb3dd7d15c5
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/87980
    Reviewed-by: Eike Rathke <erack at redhat.com>
    Tested-by: Jenkins

diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp
index 51fe8d761..47ce84594 100644
--- a/source/text/scalc/guide/numbers_text.xhp
+++ b/source/text/scalc/guide/numbers_text.xhp
@@ -77,7 +77,7 @@
          <h2 id="hd_id1005200903485368">Example</h2>
          <paragraph xml-lang="en-US" id="par_id1005200903485359" role="paragraph">In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally).</paragraph>
          <paragraph xml-lang="en-US" id="par_id1005200903485341" role="paragraph">In A2 enter <literal>=A1+1</literal> (which correctly results in 101).</paragraph>
-         <paragraph role="paragraph" id="par_id891567607263849">The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which has value 0 for the SUM function.</paragraph>
+         <paragraph role="paragraph" id="par_id891567607263849">The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function.</paragraph>
          <paragraph role="paragraph" id="par_id611567607779380"><literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.</paragraph>
       </section>
      <h2 id="hd_id871567772424915">Changing the default text to number conversion settings</h2>