Just out of curiosity, when you say "no error" do you mean that no explicit exception/error is being thrown?
If not, you may want to check the errorValue. After you evaluate the cell you should have a CellValue object, on that object call getErrorValue() which will return basically an int value. If it is non-zero, then some internal error occurred. You can get more info about the error (manually) by looking at the source of the class org.apache.poi.ss.usermodel.ErrorConstants, it has some constants for the various errors with comments that explain them. Jon ----- Original Message ---- From: Aniket Banerjee <[email protected]> To: POI Users List <[email protected]> Sent: Wed, December 29, 2010 6:58:30 AM Subject: Re: Formula evaluates wrong value. > > Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which > should return 1 is returning 0. > T2 contains "*Target Geography in all*". > Again the above formula does not return any error but simply wrong value. > And also if I skip evaluation excel calculates the correct value ie 1. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
