[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: weird Text behaviour
From:       Dominik Stadler <dominik.stadler () gmx ! at>
Date:       2020-01-22 19:55:45
Message-ID: CABdJj558RRm2MLgJ-qJBPkFArEE4Mo11Y_nsDf6YYgnft0U3hQ () mail ! gmail ! com
[Download RAW message or body]


Hi,

It seems to be caused by the format-pattern "0,00". In Europe, the "," is
the decimal separator, but in the US this is the thousands-separator, so it
seems the "0,02"  is resulting from seeing the pattern "0,00" the US-way.

It seems Excel somehow still interprets this as decimal-separator in this
case, maybe via some heuristic or when the locale is European.

In LibreOffice (sorry, no Excel here at the moment), if you enter "0.00" as
text-pattern instead, it will still display it correctly, but also Apache
POI will use the correct format.

By using something like Locale.setDefault(Locale.GERMAN); you can force the
European digit-formatting in the resulting text in Apache POI.

Dominik.

On Fri, Jan 17, 2020 at 7:55 PM Hans Schevers <hans.schevers@gmail.com>
wrote:

> Hi all,
>
> I found some weird behaviour when evaluating the cell formula
> '=TEXT(2,45;"0,00")':
>
> As expected, in Excel this results to the number 2,45 (Dutch Local so the
> decimal character is ',').
>
> Using POI and the FormulaEvaluator().evaluate(...) it returns '0.02'. I
> expected 2.45.
>
> Could this be a bug or do I need to set some extra Local properties?
>
> thanks in advance.
>
> cheers,
> Hans
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


[prev in list] [next in list] [prev in thread] [next in thread]