HYPERLINK function does nothing?

HYPERLINK function does nothing?

Posted by: jb9244 on 25 September 2018, 1:00 pm EST

• 

  jb9244

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 September 2018, 1:00 pm EST

  SpreadJS 11

  The release notes for SpreadJS mentions that HYPERLINK function support was added. SpreadJS does recognize HYPERLINK as a built-in function, but it doesn’t appear to do anything. For example, enter the following into a cell:

  =HYPERLINK(“http://www.grapecity.com”, “Grape City”)

  That cell will show the text “Grape City” but it will not be styled as and will not act like a hyperlink when clicked.

  Is this a defect or a known issue, or was it simply added to prevent those cells from showing errors when imported from Excel?

  Thanks.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 26 September 2018, 5:27 am EST

  Hello,

  We are able to replicate the issue and hence we have escalated the same to our concerned team for further investigation.

  Tracking id for your issue is #264575

  We will get back to you as soon as we hear anything from our concerned team.

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 26 September 2018, 5:35 am EST

  Hello,

  Our developers have confirmed that it is not supported as of now, and is already in the product backlog but we don’t have any ETA for the same.

  Thanks,
  
  Reeva

• 

  adisa.craig

  • Post Options:
  • Link
    Copy

  Posted 4 June 2019, 5:33 pm EST

  Hi Reeva,
  
  Is there a way for me to extend a method and write our own implementation of the hyperlink as a workaround until, the fix for this is released?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2019, 1:58 am EST

  Hi Adisa,

  You could use HyperLink CellType to display links into the workbook. Please refer to the following sample demonstrating the same:
  
  https://www.grapecity.com/demos/spread/JS/TutorialSample/#/demos/hyperLinkCellType