[Libreoffice-bugs] [Bug 109189] Internal SUM calculation of over 6 negative decimal values results in rounding error

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from C.Drewke <c.drewke at gmail.com> ---
I am not sure I fully understand what you mean - 

When I use "=SUM(A1:A6)" in A7 it also calculates "0" for me.

When I format the cells to use only 2 decimals it shows 0,00


BUT:
When I remove the negative ("-") from the values I get a precise 288,2 when I
select cells A1:A6 without formatting them previously

ALSO:
When I import these values from a database (mysql via a LibreOffice Base ODB in
my case) with a SUM calculation in the SQL query it still outputs
"-7,105427357601E-15". The fields that are used have the double(15,2) format.

As "-7,105427357601E-15" is also displayed when running that query from the ODB
file I think this bug is not in based in Calc ...

-- 
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/20170724/a20e8f43/attachment-0001.html>