Issue 79864 - COUNTBLANK won't handle discontinuous or external ranges
Summary: COUNTBLANK won't handle discontinuous or external ranges
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial with 1 vote (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: 2021-06-01 13:13 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.10
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
Comment 2 oooforum (fr) 2021-06-01 13:03:00 UTC
Note that COUNTBLANK can't handle an external range too.
=COUNTBLANK(''file:///<Dir...>/foo.ods'#$Sheet1.A1:A3) don't work.