Issue 25923 - COUNTIF does not deal with operators correctly:
Summary: COUNTIF does not deal with operators correctly:
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-26 19:17 UTC by oliinman
Modified: 2004-03-01 11:41 UTC (History)
1 user (show)

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

Attachments
Here cell B51 contains the error... (6.61 KB, application/vnd.sun.xml.calc)
2004-02-26 19:18 UTC, oliinman 		no flags Details
Whoops, this is the saved file with the problem, please disregard first (6.69 KB, application/vnd.sun.xml.calc)
2004-02-26 20:50 UTC, oliinman 		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 oliinman 2004-02-26 19:17:02 UTC 
Given a colum of data, COUNTIF(A1:A15, > B1) returns Err510.
Comment 1 oliinman 2004-02-26 19:18:09 UTC 
Created attachment 13452 [details]
Here cell B51 contains the error...
Comment 2 oliinman 2004-02-26 20:50:27 UTC 
Created attachment 13459 [details]
Whoops, this is the saved file with the problem, please disregard first
Comment 3 frank 2004-03-01 11:41:37 UTC 
Hi,

Prio is mutch to high, 3 will fit better.

Also it's not a bug but a wrong formula.

Should be COUNTIF(A1:A15;">B1") as a semicolon is the parameter delimiter for
Calc and "*" is used for the criterion.

Frank
Comment 4 frank 2004-03-01 11:41:59 UTC 
closed invalid