There is no way to get it to display URLs as links without doing some scripting. I can help you with that, though, if you share what you have for code so far.
On Wednesday, April 17, 2013 8:56:51 PM UTC-4, Chris Fortunato wrote: > > I guess I'm really trying to do this without writing any script only > because I just don't have any experience or knowledge with that stuff. And > you're right, when I convert to a table all that shows is the text. > > On Friday, November 30, 2012 1:20:22 AM UTC-5, asgallant wrote: >> >> Yes, you can have the cells hyperlinked. I am uncertain as to whether or >> not the spreadsheets will return a hyperlink in a query (I suspect that >> they return the text of the link and not the HTML to create it). If you >> add the url itself in a column in the spreadsheet, though, you can format >> the data returned by a query as a hyperlink. >> >> On Thursday, November 29, 2012 11:30:10 PM UTC-5, Chris Fortunato wrote: >>> >>> I have create an google spreadsheet that has hyperlink in many of the >>> cells. These hyperlinks link to individual Google Sites. The google >>> spreadsheet sits on a Google Site and serves as a homepage or dashboard of >>> all the google sites. I used the =hyperlink() formula in each cell. >>> >>> When I convert the google spreadsheet into a Table, I can no longer >>> click on the text in the cells to have it take me to the hyperlink >>> associated with it. >>> >>> The reason I want to convert the spreadsheet into a Table is that it >>> looks WAY nicer/cleaner and you can sort individual columns. >>> >>> My question is: Is there a way to convert a spreadsheet into a table and >>> allow the cell values to be hyperlink to a google site or any website for >>> that matter? >>> >> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
