Bug 98216 - SUM is not adding up correctly
Summary: SUM is not adding up correctly
Status: RESOLVED DUPLICATE of bug 97897
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2016-02-27 07:10 UTC by Jon 'Smith' Camilleri
Modified: 2016-02-27 10:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

spreadsheet in xlsx format (5.30 KB, application/zip)
2016-02-27 07:10 UTC, Jon 'Smith' Camilleri

Note You need to log in before you can comment on or make changes to this bug.
Description Jon 'Smith' Camilleri 2016-02-27 07:10:15 UTC
Created attachment 123022 [details]
spreadsheet in xlsx format

SUM formula (E13) is not adding up correctly, the reason is still unknown, as per attached.
Comment 1 raal 2016-02-27 09:49:00 UTC
Tested with Version:
Build ID: aaca25d67eb5ea252730cdcf555ecc04ce04a5e6
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-02-24_23:58:47

E13 = -€51 100,00 -  correct value. Try to do recalculation - CTRL+SHIFT+F9. Specify your version of LO.
Comment 2 Cor Nouws 2016-02-27 10:37:42 UTC
Hi Jon,

Thanks for filing. It's my idea that this is bug 97897.
If not reopen please and explain.
Ciao - Cor

*** This bug has been marked as a duplicate of bug 97897 ***