Hi Aniket, >> 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.
Yesterday you asked for build instructions because you had changed some POI source. Are the errors that you are encountering using your own build of POI? If so, does the error show itself with the distributed, official POI 3.7 build? If so, then perhaps it is a bug with wildcards and COUNTIF. Please try different versions of "*"&"Geography"&"*" like "*Geography*" to see. And then also a nightly build. Of course, since you are building your own you can always modify the COUNTIF function and see exactly what is doing. Regards, Dave --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
