[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 bugzilla-daemon at bugs.documentfoundation.org
Tue Apr 13 15:57:47 UTC 2021


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

--- Comment #11 from TheWebMachine <thewebmachine at gmail.com> ---
I've been a dev for 25+ years and still code for embedded controllers with FAR
LESS CAPABILITY to this day. I know how floating point in binary works (have
you ever built floating point math in pure assembly on an 8- or 16-bit
microcontroller? because I have).

Ex$cel only shows that level of "precision" if you tell it to. It doesn't
complicate matters by making that perspective the default. How hard is it to
say "we know we're not adding 0.0000000000000000736277477273 anywhere along the
way so let's not show that many digits in the result because we know it's
definitely wrong?"

Y'all speak of performance penalties, but really what penalty are we talking
about here? I'm not running a 386 with 1MB of RAM...and neither are you, I'd
hope!

-- 
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/d7f1949d/attachment.htm>


More information about the Libreoffice-bugs mailing list