[Libreoffice-bugs] [Bug 41480] Sum function doesn't work accurately over 900 lines

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=41480

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|LibO 3.4.3 release          |LibO 3.3.3 release
  Status Whiteboard|                            |CONFIRMED
           Keywords|NEEDINFO                    |
           Severity|major                       |normal
         AssignedTo|libreoffice-bugs at lists.free |kohei.yoshida at gmail.com
                   |desktop.org                 |

--- Comment #3 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 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.