poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hannes Erven <han...@erven.at>
Subject How to handle localized formulas?
Date Fri, 06 Oct 2017 13:30:12 GMT

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message