Hi,
we've run into an issue where the POI Formula Evaluator produces a
different result than Excel.
A bug has been filed:
https://bz.apache.org/bugzilla/show_bug.cgi?id=61495
... but so far the bug has not received any comments.
The formula is "=TEXT(<cell>; "00,00").
The value 67,12 is rendered as 67,12 in Excel but as 0,67 by POI.
If we change to formula to "=TEXT(<cell>; "00.00"), the output is
reverse: 0.67 by Excel and 67.12 by POI.
It seems there is confusion about whether ./, is the decimal or grouping
separator in the number format... is a standard solution to this?
Thanks!
Best regards,
-hannes
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
