https://bugs.freedesktop.org/show_bug.cgi?id=41480
Summary: Sum function doesn't work accurately over 900 lines
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: All
OS/Version: All
Status: NEW
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=52010)
--> (https://bugs.freedesktop.org/attachment.cgi?id=52010)
Examples of sums going beyond 900
Steps to reproduce:
Create a file with over 1,500 items in (to 2 or 3dp).
Create a sum function for a1:a1000
The result will have a total ending .xxx9999999
Create a sum function for a1:a1500
The result will have a total ending .xxx9999998
Expected results:
Sum works correctly (as it does in Excel)
Examples:
See attached spreadsheet example. The point where is starts summing wrong is
not always consistent, row ~938.
Also if you sum a1:900 and a901:a1000 separately you can sum those two sums and
not get the extra decimal place inaccurate (see cell B8 vs C2)
--
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
