Bug 97451 - All sum calculations return a "0"
Summary: All sum calculations return a "0"
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.4 rc
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-30 16:30 UTC by Mike Pragit
Modified: 2016-01-30 20:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Sum function not working (35.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-30 16:30 UTC, Mike Pragit 		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 Mike Pragit 2016-01-30 16:30:14 UTC 
Created attachment 122287 [details]
Sum function not working

All of a sudden the sum of any range, even a simple one like A1:A2 with a "1" & "0" in the cells returns a zero. It seems to happen when there are formulas in the range that are returning the numbers I am try to sum. I am set to autocalculate in Tools/Cell contents, and have tried changing cell formatting all different ways. there are no errors in any of the cells in that range or the cells they refer to. the only workaround I have is to type out each cell in the range with a "+" inbetween. very tedious. Now as I'm preparing a sample sheet for you =IF(OR(ISNUMBER has stopped working and is returning a zero when it  should be a one. Please help I spent a lot of time on this sheet.
Comment 1 GerardF 2016-01-30 17:52:48 UTC 
Your IF formula returns strings "1" or "0". SUM function ignore strings.
Delete the quotes surrounding 1 and 0.
Comment 2 Mike Pragit 2016-01-30 20:24:10 UTC 
You got it!. Thank you.