Issue 65181 - Problem with Count function.
Summary: Problem with Count function.
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:
Depends on:
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: ---


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

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.