Bug 48044

Summary:	[PATCH] Implementation of COUNTBLANK()
Product:	POI	Reporter:	Mads Mohr Christensen <hr.mohr>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P2
Version:	3.6-dev
Target Milestone:	---
Hardware:	All
OS:	All
Attachments:	Implementation and test case for COUNTBLANK() Test data

Description Mads Mohr Christensen 2009-10-23 17:02:46 UTC

Attached patch are the implementation of the COUNTBLANK() function. Function was mentioned in the test case but actually not implemented. Also included in the patch are the test case.

Comment 1 Mads Mohr Christensen 2009-10-23 17:03:42 UTC

Created attachment 24412 [details]
Implementation and test case for COUNTBLANK()

Comment 2 Mads Mohr Christensen 2009-10-23 17:05:03 UTC

Created attachment 24413 [details]
Test data

Comment 3 Josh Micich 2009-10-23 17:57:07 UTC

Applied with slight simplifications in svn r829293

Thanks for adding unit tests.

BTW - I agree with your TODO comment. Another concern is how Excel behaves when other application write files with incorrect arg counts, but from what I can tell Excel(2007) reports an error "File error: data may have been lost."  It seems like it is OK for POI to crash on this condition.  We'll probably fix these globally at some point.