Issue 97733 - errors counted as 0 by countif(...,"=0)
Summary: errors counted as 0 by countif(...,"=0)
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
testcase (7.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-01-04 04:22 UTC, bfields 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:

=1/0
0
1
=COUNTIF(A1:A3;"=0")

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]
testcase
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 "issues@openoffice.apache.org".