Bug 92048 - Result of SUM() is incorrect
Summary: Result of SUM() is incorrect
Status: CLOSED DUPLICATE of bug 91590
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2015-06-13 15:37 UTC by David
Modified: 2015-12-17 09:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example ods file showing problem (27.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-06-13 15:37 UTC, David 		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 David 2015-06-13 15:37:48 UTC 
Created attachment 116500 [details]
Example ods file showing problem

The attached spreadsheet is an extract from a larger sheet but shows the problem. When opened, the sum in cell B8 is incorrect. It should be the same as cell D8. Pressing F9 to recalculate B8 does not correct the sum. Pressing CTRL-SHIFT-F9 does correct it as does changing a value in column B. 

I think this spreadsheet started as an excel file then was used in OpenOffice for a while before being maintained in LibreOffice. 

Problem was found in version 4.2.7.2 on Linux and also exists in 4.3.5.2.
Comment 1 Buovjaga 2015-06-13 16:02:09 UTC 
Confirmed.

Lowering severity as recalc works.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: d56b125f6c6c18ac40712cefc3cec06530750e15
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-13_07:08:43
Locale: fi-FI (fi_FI)
Comment 2 MM 2015-06-13 17:08:15 UTC 
Duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=91590 ???
Comment 3 Buovjaga 2015-06-13 17:39:31 UTC 
(In reply to MM from comment #2)
> Duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=91590 ???

Not the same, as attachment 116500 [details] shows the wrong result in 4.2.

However, I tested with 3.5.0 and the wrong result is not shown!

Therefore the cause of the problem can be found by bibisecting.

Ubuntu 14.10 64-bit
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 4 Eike Rathke 2015-06-17 09:30:53 UTC 
This is the same as in bug 91590, the wrong value 37608 is stored in the file.

*** This bug has been marked as a duplicate of bug 91590 ***
Comment 5 Robinson Tryon (qubit) 2015-12-17 09:13:42 UTC 
Migrating Whiteboard tags to Keywords: (bibisectRequest)
[NinjaEdit]