https://bugs.freedesktop.org/show_bug.cgi?id=41480
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|LibO 3.4.3 release |LibO 3.3.3 release Status Whiteboard| |CONFIRMED Keywords|NEEDINFO | Severity|major |normal AssignedTo|[email protected] |[email protected] |desktop.org | --- Comment #3 from Rainer Bielefeld <[email protected]> 2011-10-05 23:33:38 PDT --- > Formally it's certainly incorrect @vitriol: Yes, of course. That's done much better by Gnumeric 1.10.14, When I open reporter's sample with Gnumeric, results in the second row all have 3 decimals (what looks formally correct). When I modify A13 from "59,916" to "59,9161", the results get a tailing "1" That's also better in OOo 1.1.4, B2 shows "33939,094000", what's formally correct (I selected "6 decimals") Also OOo 3.1.1 shows "33939,094" in B2 Also OOo-dev 3.2 shows "33939,094" in B2 and when I modify A13 from "59,916" to "59,9161", the results get a tailing "1" OOo 3.4 shows the same problem as LibO, C38 shows lots of decimals (35280,0439999999) Problem is [Reproducible] with "LibreOffice Portable 3.3.3 - WIN7 Home Premium (64bit) German UI [OOO330m19 (Build:301 Tag 3.3.3.1)]" and with "LibreOffice 3.4.3 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" and with with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: 81607ad-3dca5fd-da627d2)]" EXCEL Viewer will show correct result for document saved as .xls. My conclusion: I doubt that it's a "classic floating point precision error", other Spreadsheet programs do not show the problem. Seems that problem has been always in LibO @Kohei: Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
