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


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to