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

mich...@alzetta.org 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 mich...@alzetta.org ---
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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to