I need to set a clickable link from cell at one sheet to the cell at
another sheet. Does referencing provide this?
Should I still use a setCellFormula("HYPERLINK(....)) or POI provides
another way to build a referencing?Thanks in advance -----Original Message----- From: Amol Deshmukh [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 2:26 PM To: 'POI Users List' Subject: RE: how set a hyperlink between worksheets within the same excel file ? 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:[EMAIL PROTECTED] > Sent: Sunday, May 22, 2005 8:53 AM > To: [email protected] > 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ *********************************************** This Mail Was Scanned By Mail-seCure System in Matrix Herzeliya *********************************************** --------------------------------------------------------------------- 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/
