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

Reply via email to