poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54636] getNumericCellValue return different result for visually equal numbers
Date Tue, 05 Mar 2013 12:25:54 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54636

Nick Burch <apache@gagravarr.org> changed:

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

--- Comment #2 from Nick Burch <apache@gagravarr.org> ---
This is to be expected. Excel stores the values in the file as floating point
numbers, and applies formatting rules to control how they look to the end user.
You should either use something like DataFormatter to get strings based on the
format rules, or specify the number of significant digits when comparing the
numbers.

-- 
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


Mime
View raw message