Bug 58536

Summary:	CellFormat and DataFormatter support for Accounting formats
Product:	POI	Reporter:	Nick Burch <apache>
Component:	SS Common	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
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.