Bug 58536

Summary: CellFormat and DataFormatter support for Accounting formats
Product: POI Reporter: Nick Burch <apache>
Component: SS CommonAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.13-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

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.