How to handle localized formulas?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

How to handle localized formulas?

Hannes Erven-2
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: [hidden email]
For additional commands, e-mail: [hidden email]