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 view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/PpNwQaPYVrUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
