Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=aE54EWCELfu20VM3TTw/zs4Fhwy+LB1pYlw4nFcTzULBh/jcQvfT+mDfUJVBLsibmwx3/iadxrSD7hC9m6EiItwssxTgTlPPPOX9D+6bF3MVBXCZQ16eLUh3i7IBfxj0JG8rRIWHFtgyRRuaBZRRVX9DRcN7H4AsUwVkASymRFc=;
Message-ID: <282085.84003.qm@web113608.mail.gq1.yahoo.com>
References: <1307137677204-4452662.post@n5.nabble.com>
Date: Fri, 3 Jun 2011 20:08:05 -0700 (PDT)
From: Jon Svede <jsvede@yahoo.com>
Subject: Re: Getting Decimal Instead of Text String
To: POI Users List <user@poi.apache.org>
In-Reply-To: <1307137677204-4452662.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1751138278-1307156885=:84003"

--0-1751138278-1307156885=:84003
Content-Type: text/plain; charset=us-ascii

Nick Burch posted this on the dev mailing list and I think it might apply here, 
too:

"You probably just want to apply the formatting rules to the cell when you 
extract it. org.apache.poi.ss.usermodel.DataFormatter should help here".

Though I may be wrong so take it with a grain of salt....

HTH,

Jon


________________________________
From: eugenebalt <eugenebalt@yahoo.com>
To: user@poi.apache.org
Sent: Fri, June 3, 2011 3:47:57 PM
Subject: Getting Decimal Instead of Text String

I am using Apache POI-HSSF for working with Excel files.

I have a cell in my spreadsheet that looks like "115". I verified that it is
formatted as "Text" (Format Cells -> Text).

However, when I read it in as
row.getCell(0).toString()

I get this string: "115.0"

This is incorrect. I should be getting "115" since it's explicitly formatted
as Text. How can I get the desired result? The cell can be anything, numbers
or characters, and I expect the same string as in the cell. Thanks


--
View this message in context: 
http://apache-poi.1045710.n5.nabble.com/Getting-Decimal-Instead-of-Text-String-tp4452662p4452662.html

Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
--0-1751138278-1307156885=:84003--