[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Michael Warner from comment #3)
> (In reply to Uwe Auer from comment #2)
> > From my perspective not a bug but consequence of floating point arithmetic.
> 
> Which could be mitigated by Calc rounding the result so that it has the same
> number of significant figures as the inputs.

No, unless you keep the input string (or some alternative form of the
information) along with the data. And then, it will only be useful for the
summation, and will break as soon as you do anything more complex. Which is
~100% (it's very rare to have spreadsheets not doing multiplication/division).

Kahan is a good approach to improve *bulk* summation, but generally the error
is unavoidable. E.g., it will help with 'SUM(A1:A20)', but not with
'A1+A2+A3+A4+...+A20'.

-- 
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/20210413/51e9d40e/attachment.htm>