https://bugs.freedesktop.org/show_bug.cgi?id=80638
Terrence Enger <lo_b...@iseries-guru.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Severity|major |enhancement Priority|high |medium CC| |lo_b...@iseries-guru.com --- Comment #4 from Terrence Enger <lo_b...@iseries-guru.com> --- With master commit 924a28a, pulled 2014-06-28, built and running on debian-wheezy 64-bit on a AMD-64 processor, I see: (*) I see sum 2.13162820280E-014 rather than 1.4210854715202E-014 that the reporter complains of. (*) Sorting the summed range by either ascending value or ascending abs of the value results in the zero which the reporter asks for. So, the problem is just the natural result of using binary floating point numbers while showing decimal numbers to the user. To complicate the situation, computerized addition is not commutative. IMO, using binary floating point numbers by default in a commercial environment is a wrongheaded design choice: just look at the confusion it causes Bob Bib. Still, it is a widespread choice, and I find it hard to imagine that LibreOffice wants to change it. I am setting bug status back to UNCONFIRMED to encourage further discussion. Terry. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs