diff options
| -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> |