Issue 65181 - Problem with Count function.
Summary: Problem with Count function.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-05-09 00:08 UTC by cmolinap
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
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 cmolinap 2006-05-09 00:08:55 UTC 
If I want to import a Excel spreadsheet I face a problem with COUNT function. In
Calc the COUNT function return the firs error it find, if there someone in the
data range. In Excel COUNT function count only numeric cells, it doesn't matter
if there errors in the data range. For example, if I enter #N/A, intencionally,
in a cell, in the data range, the COUNT function return #N/A.
Comment 1 frank 2006-07-03 12:29:04 UTC 
Hi,

this is a feature of Calc and therefore I would set this Issue to wontfix. But
requirements have to decide about that.

You may use counta() for this.

Frank