We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Hyperlink to cell in another worksheet

Thread ID:

Created:

Updated:

Platform:

Replies:

37344 Nov 20,2005 08:42 PM Nov 21,2005 05:23 AM Windows Forms 2
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On November 20, 2005 08:42 PM

So that others don''t have to go through the same pain I did here is how: =HYPERLINK("#Sheet1!A1\","Link Display Text") In c#: sheet.Formula = "=HYPERLINK(\"#Sheet1!A1\",\"Link to A1\")" It would be nice if this was in the FAQ. I should note that Excel 2003 doesn''t color the hyperlink in blue or underline it. To work around that I''ve used CellStyle to make it look like a link.

Ramu [Syncfusion]
Replied On November 21, 2005 05:10 AM

Hi Gregorio, Here is the another way of implementing link to the cell in another worksheet.IHyperLink is the interface used to create hyperlink to the cell in another workbook. //Creating Hyperlink to another cell using type as Workbook IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C13"]); hyperlink.Type = ExcelHyperLinkType.Workbook; hyperlink.Address = "Sheet2!A15"; hyperlink.ScreenTip = "Click here"; hyperlink.TextToDisplay = "Hyperlink to cell A15 in sheet2"; Please take a look at the attached sample and let me know if you have any questions. Thanks for using Syncfusion Products. Best Regards, Ramu. hyperlinkdemo.zip

Ramu [Syncfusion]
Replied On November 21, 2005 05:23 AM

Hi Gregoria, Sorry for the inconvenience caused. Here is the correct link: hyperlinkdemo.zip Thanks, Ramu.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;