Plugin Author
Meitar
(@meitar)
URLs are turned into hyperlinks by the plugin automatically, so to create a hyperlink you just need to write a URL into the value of a cell, however you can not use this plugin to create a hyperlink on your WordPress page from a Google Spreadsheet with a “link label” (i.e., anchor text) other than the URL itself. You can turn off the auto-linking behavior by including the linkify="no" attribute to your sheet’s [gdoc key="KEY"] shortcode.
Do you mean to say that, GOOGLE SPRAD SHEETS HYPERLINK labels are NOT processed/recognized by your plug-in?
Plugin Author
Meitar
(@meitar)
Yes, that’s what I mean. 🙂
You see, HYPERLINK() is a Google Spreadsheets function. This plugin works by extracting the raw data values of the spreadsheet’s contents through its CSV export option. The computed value of HYPERLINK() does not work the same way in this context.
The gist is: to make hyperlinks that appear on your blog as a link, enter the URL of the web page as a direct value in your spreadsheets so that the plugin will see a URL, not a Google Spreadsheet function.
I understand the issue, but I hope it could be fixed sometimes 🙂 It would be very nice, no matter what is the solution 🙂
Linkify is good, but it is not very user friendly to have large column of links with their title on another column.
Cheers!
Plugin Author
Meitar
(@meitar)
No, =HYPERLINK() is a Google Sheets formula, but Google does not provide that as a link when exported, so there’s no way for any external program (like this plugin) to parse it for links.
If you must have a link whose anchor text is not a URL in your table, either use HTML in the cell value along with the gdoc_table_html filter, or now that the plugin also supports Google Apps Script Web Apps, write an Apps Script to do whatever other post-processing on your spreadsheet that you need.
