poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dale Monti <dmo...@linoma.com>
Subject Re: Excel values and rounding?
Date Mon, 08 May 2006 13:26:19 GMT
I could really use some help with this. Please help.

I've attached the spread sheet.

Thanks


> Hi,
> 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?
>
> Or
> Should I be doing something else with an ExtendedFormatRecord or 
> something? Maybe something that tells me to round to the 5th decimal 
> position.
>
> 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.
>
> Thanks
>
>
>
> ---------------------------------------------------------------------
> 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/
>
>

Mime
View raw message