[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133893

--- Comment #4 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(In reply to Mark Fielden from comment #3)
> To me it is a bug.
> The problem is inconsistent operation.
> a) all the numbers were entered into the text document in the same way
Maybe
ç
> b) the SUM function omitted one of the values without reporting an error
Because at least for me it is a text with dot as decimal separator.
What kind of error should be reported?

> c) the add function accumulated all the values correctly
Because only with direct references calc tries to convert numeric text in
values when there are no ambiguity.

> d) if the user hadn't thought the SUM total wrong, he could have made a bad
> decision
Like any other stuff users needs to know how to use the tools, and at the
contrary that it is a way to avoid a number being taking in account.

Use the right arrow on the paste button or go through paste special and paste
as non formatted selecting the proper options to get the right values pasted.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200611/71972b80/attachment.htm>