[Libreoffice-bugs] [Bug 126970] Function "SUM()" work doesn't correct if final result is zerro.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
                 CC|                            |jbfaure at libreoffice.org
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
Strange. I reproduce the problem with LO 6.3.2.0+ under Ubuntu.
But, if you change the formula to SUM(J8;J9;J10) you get 0 as expected.

So for me there is a bug because SUM(A1:A3) should give the same result as
SUM(A1;A2;A3).

Same problem with current master.
Tested with values -47.1, 4904.1, -4857 -> exactly the same result

Checking Tools > Options > LibreOffice Calc > Calculate > Precision as shown
has not effect here.

Best regards. JBF

-- 
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/20190817/d8655a68/attachment-0001.html>