What I could observe is as follows : if the cell contains "*All Geography all*" POI does calculation properly. But in case there is a line feed (by pressing ALT+ENTER) after first letter *"all*" then POI fails to calculate correctly. But excel can do the calculation in this case too. So wondering what actually is happening in this case.
@David - This happens for official POI build too. On Thu, Dec 30, 2010 at 6:23 PM, Mark Beardsley <[email protected]>wrote: > > 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: [email protected] > For additional commands, e-mail: [email protected] > >
