diff options
| author | Eike Rathke <erack@redhat.com> | 2020-02-04 14:59:03 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2020-02-04 15:19:24 +0100 |
| commit | 34b0364e6289a299fb0b50b5b0d487e37f6e9492 (patch) | |
| tree | 8397e890bc14f6a553b890ea12ddb808d43b4fe4 | |
| parent | 900d30047e754b7310ffb05a67d280b6ce7b2e7f (diff) | |
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@redhat.com>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/guide/numbers_text.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp index 51fe8d7613..47ce84594c 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> |