I'm suspicious Excel is doing extra work to translate formats for display to match the OS locale display settings even though the underlying storage always uses English standards.
On Wed, Jun 28, 2017, 11:24 <bugzi...@apache.org> wrote: > https://bz.apache.org/bugzilla/show_bug.cgi?id=60422 > > --- Comment #16 from PJ Fanning <fannin...@yahoo.com> --- > Looking at wet_test.xls, the 4.33 cell has this format. > > CELL_RECORD_TYPE > .formatindex = aa > > This cell format is added as a custom format in FormatTrackingHSSFListener. > The Format String is: > _-* #,##0.00\ "€"_-;\-* #,##0.00\ "€"_-;_-* "-"??\ "€"_-;_-@_- > > This is not what Excel run in Germany locale on My Mac shows - it shows > this > for Accounting/Buchhaltung: > _-* #.##0,00 €_-;-* #.##0,00 €_-;_-* "-"?? €_-;_-@_- > > Note that the decimal and grouping separators do match up. > > I don't know much about xls data format so I saved the file as an xlsx and > checked the xl/styles.xml and the format string seems to match up to the > #,##0.00 format as opposed to #.##0,00. > > Does anyone have any insight on this? > > -- > 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 > >
