cell.setCellFormula("HYPERLINK(\"http://google.com\";\"google\";)")
should use , instead of ;
Corrected code:
cell.setCellFormula("HYPERLINK(\"http://google.com\",\"google\";)")
~ amol
> -----Original Message-----
> From: lucian chirita [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 07, 2005 10:40 AM
> To: poi-user@jakarta.apache.org
> Subject: Label of hyperlink doesn't show
>
>
> Hi
>
> I'm trying to create a hyperlink cell:
> cell.setCellFormula("HYPERLINK(\"http://google.com\";\"google\";)")
>
> The hyperlink gets created (it opens the URL when the cell is
> clicked),
> but insted of the label the cell shows "0".
>
> I'm using MS's Excel Viewer 2003 to open the file. In Open Office it
> shows =#NAME!("http://google.com";"google";) in the cell.
>
> Any idea?
>
>
> TIA,
> lucian chirita
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
