RE: how set a hyperlink between worksheets within the same excel file ?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

RE: how set a hyperlink between worksheets within the same excel file ?

Amol Deshmukh
If you meant referencing and not hyperlinking:

for referencing cells from different sheet in same workbook,
you do not need to specify the workbook name.
ie. worksheet!cell will work just fine.

~ amol



> -----Original Message-----
> From: Vadim Gorlovetsky [mailto:[hidden email]]
> Sent: Sunday, May 22, 2005 8:53 AM
> To: [hidden email]
> Subject: how set a hyperlink between worksheets within the same excel
> file ?
>
>
> I am looking for a way for linking between cells of different
> worksheets
> within the same excel file.
>
> The format of hyperlink [workboardName]worksheet!cell seems the only
> option suitable for this.
>
> The only problem is a workboardname.
>
> If user saves a file on a filesystem, so a workboard name is a file
> name, that application generates.
>
> Hyperlink works fine in this case.
>
> But when user chooses to open the document, generated by servlet,
>
> the name is changed with depend on number of versions in the
>
> "temporary files", so a file name changes from "reportXXXX.xls"
>
> to "reportXXXX[1..X].xls" and hyperlink does not work.
>
>  
>
> Is there any way to detect/set a current workboard name ?
>
>  
>
> Thanks
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/