<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Internal SUM calculation of over 6 negative decimal values results in rounding error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Internal SUM calculation of over 6 negative decimal values results in rounding error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189">bug 109189</a> from <a class="email" href="mailto:c.drewke@gmail.com" title="C.Drewke <c.drewke@gmail.com>"> C.Drewke</a> <pre>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 ...</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>