Summary: | DataFormatter not removing locale for number cell | ||
---|---|---|---|
Product: | POI | Reporter: | Robert Kish <robert_kish> |
Component: | POI Overall | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.8-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP |
Description
Robert Kish
2012-06-08 20:09:04 UTC
Is the lack of locale removal only affecting the General case, or does it apply to all formats (custom and built in)? (This should help us work out what area to focus on) (In reply to comment #1) > Is the lack of locale removal only affecting the General case, or does it > apply to all formats (custom and built in)? > > (This should help us work out what area to focus on) General and @ are the ones not working as expected. Other formats, such as ## and 00 are working fine when a locale is present. These 2 fail: assertEquals("63", dfUS.formatRawCellContents(63.0, -1, "[$-1010409]General")); assertEquals("63", dfUS.formatRawCellContents(63.0, -1, "[$-1010409]@")); These 2 are fine: assertEquals("63", dfUS.formatRawCellContents(63.0, -1, "[$-1010409]##")); assertEquals("63", dfUS.formatRawCellContents(63.0, -1, "[$-1010409]00")); I put all 4 formats in Excel 2003, and when saved to CSV, they export as "63". |