https://bugs.documentfoundation.org/show_bug.cgi?id=156985
Bug ID: 156985
Summary: SUM() with mixed formula and value cells may give
slightly inaccurate result
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Spin-off of bug 68448.
Using its attachment 84471 observe:
=RAWSUBTRACT(0;A1;A2;A3;A4;A5) gives 2.8421709430404E-14 that is the "raw"
subtraction with IEEE 754 double values. The status bar does the same.
=A1+A2+A3+A4+A5 gives 0 as individual operator+ and operator- calculations try
to tie the result to 0 if applicable.
=SUM(A1:A5) gives -1.59872115546023E-14 using the Kahan summation algorithm.
The problem here is A1 being the formula =-170.87, replacing that with value
-170.87 also =SUM(A1:A5) results in 0.
Apparently since LO 7.2 when Kahan summation was introduced. Which generally
gives more accurate results than the previous SUM() algorithm.
--
You are receiving this mail because:
You are the assignee for the bug.
