Skip navigation
ctongac
ctongac Calculating status...
Currently Being Moderated

How to insert hyperlink into spreadsheet in CF9.0.1?

Mar 15, 2012 1:43 AM

Tags: #coldfusion9 #cfspreadsheet #cf9 #spreadsheetsetcellvalue

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

519 Views   2 Replies   Latest reply: ctongac, Mar 28, 2012 9:31 PM
 
Replies
  • -==cfSearching==-
    Currently Being Moderated
    1. -==cfSearching==-,
    Mar 22, 2012 7:05 AM   in reply to ctongac
    Report

    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);

     
    |
    Mark as:
  • ctongac
    Currently Being Moderated
    2. ctongac,
    Mar 28, 2012 9:31 PM   in reply to -==cfSearching==-
    Report

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

     

    Thanks!

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points