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