Bug 58536 - CellFormat and DataFormatter support for Accounting formats
Summary: CellFormat and DataFormatter support for Accounting formats
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.13-dev
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2015-10-25 20:59 UTC by Nick Burch
Modified: 2015-10-25 21:48 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Nick Burch 2015-10-25 20:59:58 UTC
Spotted while working on #58532, accounting cell formats such as

   _-[$£-809]* #,##0_-;\-[$£-809]* #,##0_-;_-[$£-809]* "-"??_-;_-@_-

(Which should be \s£\s+12,345\s or -$\s+12,345) aren't being correctly formatted by CellFormat and DataFormatter. While we won't do anything fancy with looking up the locale code in the currency specifier, we should at least be able to spot that they're localising a $ into a £ and render as such
Comment 1 Nick Burch 2015-10-25 21:48:37 UTC
Basic support added in r1710484. We don't yet do anything with the locale information (though DateFormatConverter does know about them if we ever did want to), we at least now turn something like "[$£-809]" into "£" so it looks much as it does in Excel.