poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dale Monti <dmo...@linoma.com>
Subject Excel values and rounding?
Date Thu, 04 May 2006 16:40:10 GMT
I am reading a spread sheet and I am using NumberRecord  - getValue() I 
get a value of 0.021419999999999998. However in Excel the value appears as
0.02142000000000000000000 , after I increased the decimal positions.

Is there any way in Excel to show the non-rounded number?

Should I be doing something else with an ExtendedFormatRecord or 
something? Maybe something that tells me to round to the 5th decimal 

My user claims I am reading it incorrectly, so I either have to prove to 
them what the actual number is or do some type of rounding.


To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

View raw message