Bug 96836 - SUM function in Calc not summing correctly
Summary: SUM function in Calc not summing correctly
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-30 21:03 UTC by Greg TH
Modified: 2015-12-30 21:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
SUM function, LibreOffice vs Excel (11.09 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-12-30 21:03 UTC, Greg TH 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Greg TH 2015-12-30 21:03:55 UTC 
Created attachment 121648 [details]
SUM function, LibreOffice vs Excel

Summing a set of 10 numbers with two-decimal precision does not yield the correct answer.  The three columns in the attached document show the numbers summed in LibreOffice (showing an incorrect result), the last digit only summed in LibreOffice (showing that the final digit should be "8" not "6"), and the same set of numbers summed in Excel (yielding the correct result).  If this is not a bug in LibreOffice, then please indicate what I am doing wrong.
Comment 1 Julien Nabet 2015-12-30 21:38:15 UTC 
When entering these cells:
- A2 is equal at 43.645 
- A3, 43.775
- A9, 48.235
- A10, 46.435
So when you sum up, then (and only then), LO rounds at 2 decimals.

You don't have exactly these value on column E.