How to link other sheet or other cell using the HyperLink?

Posted by: lastday1225 on 8 September 2017, 2:51 pm EST

  • Posted 8 September 2017, 2:51 pm EST

    hi, mate.

    Recently my boss asked to me adding function hyperlink like the MS excel.

    For example,

    if we write to excel Vba code,

    Sheets("P&L").Hyperlinks.Add Anchor:=Sheets("P&L").Cells(1, 1), _
    Address:="", SubAddress:=Cells(5, 5).Address

    But, I think that the farpoint hyperlink support just only website address.

    How to link other sheet or other cell using the HyperLink?

    And, perhaps if not support this feature using hyperlink class, do I need to use the cellClickEvent? (if clicked, SetActiveSheetIndex...)

    If I do work like this one, this feature can't do work when I export Excel files.

    Please apply to me.

  • Replied 8 September 2017, 2:51 pm EST

    Hello,

    I have submitted an enhancement request for the future versions of Spread, and the request id for the same is #99924057.

    Thanks,

    Manpreet Kaur.

  • Replied 8 September 2017, 2:51 pm EST

    Hi Matt,

    Current I have same requirement as lastday1225,I need one winform hyperlinkcelltype cell which support being clicked, it will link to another cell in current sheet.

    As you said in the latest post, there is #99924057 for this.

    Can you tell me the status about this request? thank you.

  • Replied 8 September 2017, 2:51 pm EST

    Hello,

    I would like you to know that enhancement request number #99924057 is meant for exporting HyperLinkCellType to excel as a hyperlink object  and is still under consideration. You can refer to the following link that describes how you can use a HyperlinkCellType to link to a cell in the current sheet:

                           http://www.clubfarpoint.com/Forums/forums/thread/95379.aspx

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 2:51 pm EST

    Hi Matt,

    Actually I had found the post http://www.clubfarpoint.com/Forums/forums/thread/95379.aspx before.

    My requirement for linking to other cell using hyperlink perhaps is special, I opearte the farpoint spread object in background and eventually Save this farpoint spread object to

    Excel document. I'd like linking to other cell function works well in this Excel document. So those events are not available for me B/C I don't have any UI operation.

    Next question, I try to found use VAB or Macro to complete this functionality, but Farpoint Spread doesn't support VBA or Macro.

    Do you still have some suggestions for my requirement?

  • Replied 8 September 2017, 2:51 pm EST

    Hello,

    You could refer to the following link which would guide you ahead, by providing a sample, on how you could using a HyperLInkCellType to link to a cell in the same sheet or to link to a different sheet. 

            http://www.clubfarpoint.com/Forums/forums/thread/95379.aspx

    And, I would like to know that by default neither the HyperlinkCellType is exported or not imported. Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur.

  • Replied 8 September 2017, 2:51 pm EST

    Thank you, mate.

    I trying to export to excel files. I know that almost different components support it.

    But, as mentioned before the farpoint hyperlink class not support real hyperlink cell.

    I would like to know that Grapecity have a plan about this feature.

    I think that this feature is very important and basically feature.

  • Replied 8 September 2017, 2:51 pm EST

    Hello,

    Currently, this is the only way possible to achieve the linking between the cells using HyperLinkCellType which actually cannot be exported to Excel. There is no other way to implement the same.

    Thanks,

    Manpreet Kaur

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels