Issue 79864

Summary:	COUNTBLANK won't handle discontinuous or external ranges
Product:	Calc	Reporter:	psyctc <chrishold>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, oooforum
Version:	OOo 2.2.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.10
Developer Difficulty:	---

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.