poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kenneth Cheung <kenneth_che...@scotiacapital.com>
Subject Re: Problem reading "AB.CD.E" as a string
Date Fri, 07 Mar 2003 15:52:44 GMT

I take it that you mean a formula cell that references a string?   I have no
problem reading formula cells that produce numeric values (e.g. =1+2 or
=A1+100 or =A1+A2)...

thanks

Avik Sengupta wrote:

> reading the  value of a formula cell is not yet supported :(
>
> On Fri, 2003-03-07 at 20:48, Kenneth Cheung wrote:
> >
> > 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


Mime
View raw message