poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49928] formatCellValue returns incorrect value for £ formatted cells
Date Fri, 08 Oct 2010 08:42:25 GMT

Yegor Kozlov <yegor@dinom.ru> changed:

           What    |Removed                     |Added
             Status|REOPENED                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #6 from Yegor Kozlov <yegor@dinom.ru> 2010-10-08 04:42:22 EDT ---
Fixed in r1005726, junit added. 

The problem workbook demonstrates an unexpected behavior. Excel has a set of
built-in formats referenced by an integer id in the range [0, 164]. If a custom
format is applied then it is created with a new id above 164. This behavior is
observed in Excel 2003 and Excel 2007, both for the .xls and .xlsx formats.

In your case a custom format was applied, but its formatId was 6, i.e. in the
built-in range. As the result, DataFormatter picked up a wrong built-in format
with Dollar instead of Pound. 

I fixed the order in which formats are checked, now overridden formats have
higher priority than built-in ones regardless from formatId. 


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

View raw message