Bug 132556 - wrong sum of formula results
Summary: wrong sum of formula results
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-30 13:10 UTC by Friedrich Strohmaier
Modified: 2020-04-30 17:57 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Calc document containing highlighted calculation errors (14.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-30 13:10 UTC, Friedrich Strohmaier 		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 Friedrich Strohmaier 2020-04-30 13:10:48 UTC 
Created attachment 160127 [details]
Calc document containing highlighted calculation errors

Attached document contains several formulas where the sum of some results with
one EURO cent missing.

I've marked them red to make it clear.
I could not detect any rounding or foramtting issues.
The errors survived several document changes to remove personal data.

To examine simply 
- download attached file
- open with LibreOffice calc
- evaluate the results
Comment 1 Friedrich Strohmaier 2020-04-30 14:30:17 UTC 
Following this thread in de-discuss mailinglist [1] it is a rounding issue which I did not detect due to missing knowledge about foramatting.

[1] https://listarchives.libreoffice.org/de/discuss/msg23612.html

so all well ;o))
Comment 2 Friedrich Strohmaier 2020-04-30 17:57:52 UTC 
Quickfix

to get rid of this, set:
Tools -> options -> LibreOffice Calc -> Calculate -> [x] Precision as shown

You probably face performance issues with this setting.