poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61874] OperandResolver.parseDouble(String) does not does not work for numeric Strings using a comma as decimal separator.
Date Wed, 13 Dec 2017 10:17:30 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61874

--- Comment #2 from Carl Salaets <carl.salaets@gmail.com> ---
After changing the locale, reopening the xlsx, recalculating the formula, the
result changes. Excel always tries to give a result, which may be unexpected.
Here is an overview:

------------------------------------------------------------------

Locale with (1,234.68)
- Thousand Separator = ,
- Decimal Separator  = .

         Value           Format          =TEXT(Value;Format)
                                         Excel           POI
        1234,68         #.##0,00        1234,68         #VALUE!
        1234,68         #,##0.00        1234,68         #VALUE!
        1234.68         #.##0,00        1234.68000      1234.68
        1234.68         #,##0.00        1,234.68        1,234.68

------------------------------------------------------------------

Locale with (1.234,68)
- Thousand Separator = .
- Decimal Separator  = ,

         Value           Format          =TEXT(Value;Format)
                                         Excel           POI
        1234,68         #.##0,00        1.234,68        #VALUE!
        1234,68         #,##0.00        1234,68000      #VALUE!
        1234.68         #.##0,00        1234.68         1234.68
        1234.68         #,##0.00        1234.68         1,234.68

------------------------------------------------------------------

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message