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

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

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