poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shinya Koizumi" <shi...@smartestdesign.com>
Subject Re: Excel values and rounding? Urgent!!!!
Date Wed, 10 May 2006 22:00:42 GMT
> >> Is there any way in Excel to show the non-rounded number?
just put ' to make it to string in the Excel. Also the non-rounded number
is displayed in the formula bar.

Shinya

----- Original Message -----
From: "Dale Monti" <dmonti@linoma.com>
To: "POI Users List" <poi-user@jakarta.apache.org>
Sent: Wednesday, May 10, 2006 2:16 PM
Subject: Re: Excel values and rounding? Urgent!!!!


> Could someone please take a look at this, this is becoming a real
> problem for me.
> Thanks!!
>
> Dale Monti wrote:
> > 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/
> >>
> >>
> > ------------------------------------------------------------------------
> >
> > ---------------------------------------------------------------------
> > 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/
>



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