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

we've run into an issue where the POI Formula Evaluator produces a
different result than Excel.

A bug has been filed:

... 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?


Best regards,


To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]