Issue 79864 - COUNTBLANK won't handle discontinuous ranges
Summary: COUNTBLANK won't handle discontinuous ranges
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-21 19:48 UTC by psyctc
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description psyctc 2007-07-21 19:48:45 UTC
The COUNTBLANK function won't handle a non-contiguous range so
=COUNTBLANK(A1:A3) works fine but =COUNTBLANK(A1; A3) results in an error
message (504 I think it was).  This behaviour matches Excel I see but it's a bit
of a pain.  I see it as a bug but I suppose if you see Excel compatibility as
primary it may not be.
Comment 1 frank 2007-07-23 10:03:33 UTC
Hi,

not a defect as it works as defined and is compatible to the other spreadsheets.
But let's requirements decide on this enhancement request. 

Frank