tracker issue : CF-4175063

Matt, Thanks for raising this request and for sharing the implementation details. I just wanted to get your perspective on the expected behavior for different types of content that the hyperlink can point to. I guess, this feature would be most relevant if the link is pointing to someplace in the same excel document (say different cell, or cell in another sheet). But how would you expect it to behave if it is pointing to a webpage, or some content in the local file-system? Also, can you share the specific use case you need this for, so that we have at least one real world scenario for this feature.

Comment by Piyush K.

I didn't think about the cases in which it would point to a local directory or a location in the same document, my use case was when it pointed to an external webpage. I was able to make it work the way I want it to, by using the code in the attached file. I extracted the external webpage link as a string. This is why I needed it: I get a spreadsheet from a source, I don't have any say on how this spreadsheet is formatted, but each row has a cell with a hyperlink to a webpage. The Text for the hyperlink is not the link itself. SO i need the underlying data. My job is to take all of the spreadsheet data and organize it and separate it into structs of json Data. So to do that I convert the spreadsheet to a query object and then dissect the information from there. But at that point hyperlink data is lost, i just get the text value like "Link 1" for example. So, what I wanted to do was before converting it to a query object, was take the spreadsheet, loop through the column with all my links, and run a function like SpreadsheetGetCellHyperlink(spreadsheet,row,column) similar to SpreadsheetGetCellFormula(spreadsheet,row,column). and it would return the hyperlink in the form of a string. right now this is accomplished by creating all the necessary POI java objects in coldfusion to loop through a spreadsheet, and when you finally get down to the cell level you can run cell.getHyperlink(); a java function in the apache library. can this function be wrapped up to use straight from the coldfusion spreadsheet interface instead of having to go to java to dissect the spreadsheet? the function I wrote returns all the hyperlinks in an array, each spot in the array represents a row and all links found in that row. It's an array of structs. array[1] = {"col_1"="www.etc.com","col_4"=""...etc} which i think is a logical thing to return if you want to get all the links in the spreadsheet and then just get the specific link you want by sifting through that array. So maybe the function should be SpreadsheetGetHyperlinks instead of SpreadsheetGetCellHyperlink. either way, this is the only thing i found to fix my problem was this java workaround and I think it would be helpful to include it in the spreadsheet functions. Thanks for the reply, look forward to a response. matthew

Comment by External U.

Real world scenario: A city has publicly available information about building permits that are requested. This info is in a spreadsheet that anyone can download. Column one of this spreadsheet holds the info for the Permit Number. Suppose the first record has permit number 1111. That 1111 has a hyperlink that points to a unique webpage with more info on that permit. I want to take the spreadsheet and dissect each record and present all of it's information to a client. I would also like to provide the unique link to the client so they can look at the permit details directly on this external site provided by the city in question. So, I need to get the hyperlink data from the cell, similar to how you would get the format data from a cell.

Comment by External U.

I am attaching the spreadsheet I built this for.

Comment by External U.