https://bz.apache.org/bugzilla/show_bug.cgi?id=61495
--- Comment #1 from Axel Howind <a...@dua3.com> ---
>From my experience, localized Numberformats in Excel, such as "0,00" will be
stored as "0.00" internally. All number formats seem to be stored according to
US locale conventions with a dot ('.') separating the fraftional part. The
comma (',') is used as a grouping character. In german locale, it is reversed.
Excel automatically translates dots and commas when used as a number format,
but I doubt it also does so when using a formula. I think that should be
checked first before deciding how POI should handle this.
A fun fact is that even the Excel help at least for german Excel 2010 is
completely useless here because it seems to have been translated without trying
out the examples given (it says that '=TEXT(A1,"$0.00") & " per hour"' will
result in '23,50 € pro Stunde', magically translating not only the number, but
also the text in quotes).
--
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
