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 2021/10/08 20:37:09 UTC

[Bug 64620] Apache POI API evaluation value - Excel value - not matching

https://bz.apache.org/bugzilla/show_bug.cgi?id=64620

PJ Fanning <fa...@yahoo.com> changed:

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

--- Comment #2 from PJ Fanning <fa...@yahoo.com> ---
Excel files store numbers as doubles and doubles are just approximations. If
you use the POI DataFormatter class, it will apply a format based on the cell
style and this can include rounding the number to the form displayed by Excel.

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