Bug 96026 - sum(D2:D4) omits D3 -- erroneous computation
Summary: sum(D2:D4) omits D3 -- erroneous computation
Status: RESOLVED NOTABUG
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: 2015-11-24 00:54 UTC by Spencer Graves
Modified: 2015-11-24 01:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
LO Calc file that displays an intermitted bug in sum(D2:D4) (12.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-24 00:54 UTC, Spencer Graves 		Details
Sample file modified to avoid the error (13.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-24 01:53 UTC, m_a_riosv 		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 Spencer Graves 2015-11-24 00:54:30 UTC 
Created attachment 120748 [details]
LO Calc file that displays an intermitted bug in sum(D2:D4)

The attached LO Calc file returns D2+D4 for SUM(D2:D4) even though D3 is a number different from zero.  It occurred under LO 5.0.0.5 and 5.0.3.2 under Mac OS X 10.11 and LO 4.3.5.2 under Windows 7.
Comment 1 m_a_riosv 2015-11-24 01:53:03 UTC 
Created attachment 120749 [details]
Sample file modified to avoid the error

Hi @Spencer, thanks for reporting.

The problem is that D2.D7 is a text not a number.

If you want the $ or other currency showed used the cell format as they are in D1 and D3