https://bz.apache.org/bugzilla/show_bug.cgi?id=60422
--- Comment #14 from PJ Fanning <fannin...@yahoo.com> --- I've been doing a bit more experimentation. It seems that simpler formats are handled correctly, locale wise. I think some of the main issues are: * DataFormatter should set the LocaleUtils user locale to match the DataFormatter locale if set (and if LocaleUtils does not have an explicit locale set already) * org.apache.poi.ss.format.CellNumberFormatter has a lot of hardcoding about commas for grouping separators and dots for decimal separators - should use DecimalFormatSymbols class * org.apache.poi.ss.format.CellNumberFormatter also applies the separator from the format string but my understanding is that "#,##0.00" means to apply locale specific separators, that the '.' is assumed to mean apply locale specific decimal separator as oppposed to specifically apply '.' as the decimal separator. * need to check if org.apache.poi.ss.format.CellNumberFormatter assumes 3 digits in each group - in India, they have lakhs and write 1 million (10 lakh) as 10,00,000 -- 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
