https://bugs.documentfoundation.org/show_bug.cgi?id=109189
--- Comment #3 from C.Drewke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
