https://bugs.documentfoundation.org/show_bug.cgi?id=68448
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #16 from Eike Rathke <[email protected]> --- =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. Need to investigate the cause and what could be done about it. -- You are receiving this mail because: You are the assignee for the bug.
