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

Reply via email to