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


Mime
View raw message