Issue 116277 - make Function Wizard: COUNTIF add quotation marks to parameter "criteria"
Summary: make Function Wizard: COUNTIF add quotation marks to parameter "criteria"
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.3 RC8
Hardware: PC Unix, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-02 14:05 UTC by niklasspille
Modified: 2014-01-12 07:09 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
counting the number of cells having a value bigger 0 in the range A1:A4 (7.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-02 14:07 UTC, niklasspille 		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 niklasspille 2011-01-02 14:05:28 UTC 
Using the function wizard to create a COUNTIF function returns error code 510
(missing variable) upon using relative values (>, <, =) in the "criteria" field.
Adding quotation marks around the "criteria" parameter in the function resolves
the problem.
Suggested enhancement: Make the function wizard add quotation marks around the
second parameter to COUNTIF automatically.
Comment 1 niklasspille 2011-01-02 14:07:31 UTC 
Created attachment 75456 [details]
counting the number of cells having a value bigger 0 in the range A1:A4
Comment 2 Edwin Sharp 2014-01-12 07:09:54 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian