https://issues.apache.org/bugzilla/show_bug.cgi?id=49928
Summary: formatCellValue returns incorrect value for £
formatted cells
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=26025)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26025)
A cell containing £1, that is formatted by POI as $1
Steps to reproduce:
1. Using a machine set to the English locale, create an xlsx file using Excel
2007.
2. Type "£1" into a cell and observe that Excel converts it to a currency type
cell with the "£" symbol. (See attachment).
3. Use POI to read the cell from step 2; call [new
org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(Cell)] on the cell.
4. Observe that the returned value is "$1", not "£1" as expected.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
