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)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
spreadsheet in xlsx format (5.30 KB, application/zip)
2016-02-27 07:10 UTC, Jon 'Smith' Camilleri 		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 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: 5.2.0.0.alpha0+
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 ***