|Summary:||[PATCH] Implementation of COUNTBLANK()|
|Product:||POI||Reporter:||Mads Mohr Christensen <hr.mohr>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Implementation and test case for COUNTBLANK()
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.