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