[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

--- Comment #4 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Jean-Baptiste Faure from comment #3)
> For me the main problem is that SUM(J8:J10) does not give the same result as
> SUM(J8;J9;J10). We have the same behavior in your test file with example in
> column C.

the sum order can influence the result:
https://www.baeldung.com/java-floating-point-sum-order

=SUM(-46,4;4904,28;-4857,88)    0
=SUM(4904,28;-46,4;-4857,88)    0
=SUM(4904,28;-4857,88;-46,4)    -3,62376795237651E-13

or: 
Bug 82865 - precision errors in sum() 
-> reproducible with LO 4.4.7.2 (with LO 5/6 result is 0)

-- 
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/20190818/4bde8f35/attachment.html>