source/text/scalc/guide/numbers_text.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 34b0364e6289a299fb0b50b5b0d487e37f6e9492
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Tue Feb 4 14:59:03 2020 +0100
Commit: Eike Rathke <er...@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 <er...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
