You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2010/09/17 16:19:59 UTC

DO NOT REPLY [Bug 49928] formatCellValue returns incorrect value for £ formatted cells

https://issues.apache.org/bugzilla/show_bug.cgi?id=49928

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |WORKSFORME

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2010-09-17 10:19:56 EDT ---
I'm pretty sure you're being bitten by an excel "feature". Excel is probably
treating your £ as a generic currency symbol, and actually storing a $ in the
file

Can you please try opening your sample file on a computer set to be in the US,
and see what you get in excel?

I've just created a file with formattings of both $00.00 and £00.00, and POI is
able to retrieve both symbols properly. So, I think the problem is with how
you're setting the format, and not with POI

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org