Just to throw another idea into the mix, the * wildcard is supposed to match any sequence of characters according to Excel's on line help. What is not clear though is what happens if there are no characters following the literal. I am wondering if Excel's interpretation may be lax - the wildcard will be looking to match zero or more characters - and POI's more strict - looking to match one or more characters. Do not know if this is the case and I cannot seem to find out from searching at MSDN but it would certainly be worth looking at the source of the COUNTIF function's implementation in POI.
Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Formula-evaluates-wrong-value-tp3321261p3322409.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
