poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "venkatesham nalla" <v_na...@hotmail.com>
Subject COUNTIF yields #VALUE! error
Date Fri, 01 Sep 2006 18:33:49 GMT

I am using the following formula in sheet named "Worksheet" 
=IF(COUNTIF(Form!$B$39:$B$45,"ABCD")>0,0,""). Populating this with 
setCellFormula() without the '=' sign. When open the spread sheet in Excel 
it shows #VALUE!, however double clicking on the cell or Click and enter key 
were able to evaluate the formula and show the results. I am using 2.5.1 
final release. Am I missing somethig or it is a bug in POI?

Appreciate you help.


To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

View raw message