Issue 97733 - errors counted as 0 by countif(...,"=0)
Summary: errors counted as 0 by countif(...,"=0)
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-01-04 04:21 UTC by bfields
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

testcase (7.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-01-04 04:22 UTC, bfields
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bfields 2009-01-04 04:21:22 UTC
Consider e.g. a spreadsheet with just:


The result in the fourth cell is 2.  Excel gives 0, which seems more natural to
me.  (Noticed importing from an excel spreadsheet to Mac OpenOffice; reproduced
OO behavior on a Ubuntu system.)
Comment 1 bfields 2009-01-04 04:22:18 UTC
Created attachment 59119 [details]
Comment 2 bfields 2009-01-04 04:23:43 UTC
(Err, sorry, I meant to say the result in the Excel case is 1, not 0.)
Comment 3 ooo 2009-01-07 12:37:26 UTC
The result of course should be 1 and not 2.
Comment 4 bfields 2010-02-04 20:50:43 UTC
Loaded testcase with 3.1.1 (from Ubuntu Karmic's openoffice-calc version
1:3.1.1-5ubuntu1), and it still gives the incorrect result (2).
Comment 5 ooo 2010-02-09 12:44:02 UTC
Please don't fiddle with the version field, it indicates for which version an
issue was reported first. Thanks.
Comment 6 Marcus 2017-05-20 11:11:18 UTC
Reset assigne to the default "".