https://bugs.documentfoundation.org/show_bug.cgi?id=115642
[email protected] changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|SUM function in Calc gives |Invalidly formatted numbers
|wrong answer |fail to trigger #VALUE! in
| |formula; was: SUM function
| |in Calc gives wrong answer
--- Comment #13 from [email protected] ---
Ok, I did as you suggested, and it works.
In my original spreadsheet (which is larger and more complicated) I even found
some zeroes which I definitely added by hand and not via "copy and paste" which
were not numbers. So there is a question about what happened to transform some
numbers into ascii characters.
So, the bug is that the sum of invalidly formatted numbers should give me
#VALUE! just as it does for you, and not a wrong answer if I use SUM(A1:A6) and
the right answer if I sum cell by cell.
A localization bug?
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
