Return-Path: <kenneth_cheung@scotiacapital.com>
Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list poi-user@jakarta.apache.org
Received: (qmail 28008 invoked from network); 7 Mar 2003 15:19:42 -0000
Received: from mail2.sdbi.com (HELO sbtoradm21.ScotiaCapital.com)
 (198.137.70.23)
  by daedalus.apache.org with SMTP; 7 Mar 2003 15:19:42 -0000
Received: from sbtormlr3.ib.tor.ScotiaBank.com
	 by sbtoradm21.ScotiaCapital.com  with SMTP id KAA28454
	for <poi-user@jakarta.apache.org>; Fri, 7 Mar 2003 10:19:44 -0500 (EST)
Received: from sbtormlr1.ScotiaCapital.com ([172.20.83.201])
 by sbtormlr3.ib.tor.ScotiaBank.com (NAVGW 2.5.2.12) with SMTP id
 M2003030710194308352
 for <poi-user@jakarta.apache.org>; Fri, 07 Mar 2003 10:19:43 -0500
Received: from scotiacapital.com
	 by sbtormlr1.ScotiaCapital.com  with ESMTP id KAA09893
	for <poi-user@jakarta.apache.org>; Fri, 7 Mar 2003 10:18:44 -0500 (EST)
Message-ID: <3E68B85D.7344AB66@scotiacapital.com>
Date: Fri, 07 Mar 2003 10:18:53 -0500
From: Kenneth Cheung <kenneth_cheung@scotiacapital.com>
X-Mailer: Mozilla 4.76 [en]C-CCK-MCD   (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: poi-user@jakarta.apache.org
Subject: Problem reading "AB.CD.E" as a string
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-MailScanner-SpamCheck: 
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N


Hi,

Suppose in cell B9 I have a string "AB.CD.E" and in cell B10, I have
"=B9".

While I have no problem getting the string in B9 using
cell.getStringCellValue( ), I get a null if I try to read the value of
B10.

Now, if I use cell.getNumericCellValue( ) I get "NaN"  (not a number?)

I'm using Dev version 1.8.0 running on Solaris w/ JDK 1.3

Any help would be greatly appreciated.

Thanks
Ken