poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56317] While reading excel (.xls) numeric value "0.002877" and its multipes of 2 & 4 and division of 3 it shows 19 decimals insted of 6.
Date Wed, 26 Mar 2014 09:40:55 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56317

Nick Burch <apache@gagravarr.org> changed:

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

--- Comment #1 from Nick Burch <apache@gagravarr.org> ---
That's just how floating point values work

If you want to format a cell as a string, as it looks in Excel, use
DataFormatter.formatCellValue(Cell)

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