Hi all, I found some weird behaviour when evaluating the cell formula '=TEXT(2,45;"0,00")':
As expected, in Excel this results to the number 2,45 (Dutch Local so the decimal character is ','). Using POI and the FormulaEvaluator().evaluate(...) it returns '0.02'. I expected 2.45. Could this be a bug or do I need to set some extra Local properties? thanks in advance. cheers, Hans --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
