https://bz.apache.org/bugzilla/show_bug.cgi?id=61874
--- Comment #2 from Carl Salaets <carl.sala...@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-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
