Skip to main content
C
ctongac
Participant
March 15, 2012
Answered

How to insert hyperlink into spreadsheet in CF9.0.1?

  • March 15, 2012
  • 1 reply
  • 2407 views

I was trying to insert a hyperlink into a cell of a spreadsheet like <a href="http://www.adobe.com">Go here</a> but there is no way to convert the cell value to hyperlink. It is not documented anywhere either. Please advise.

Thanks,

Chee

This topic has been closed for replies.
Correct answer -__cfSearching__-

It is not very obvious. You can create links using a formula and Excel's Hyperlink() function. Not tested, but something like this

     SpreadsheetSetCellFormula(sheet, 'HYPERLINK("http://www.adobe.com", "Go Here")', rowNumber, columnNumber);

1 reply

-
-__cfSearching__-Correct answer
Inspiring
March 22, 2012

It is not very obvious. You can create links using a formula and Excel's Hyperlink() function. Not tested, but something like this

     SpreadsheetSetCellFormula(sheet, 'HYPERLINK("http://www.adobe.com", "Go Here")', rowNumber, columnNumber);

C
ctongacAuthor
Participant
March 29, 2012

That works! However it does not appear in blue and underline but there is an easy fix with SpreadsheetFormatCell.

Thanks!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices