Google Sheets Hyperlink Functiin | ww.wp.xz.cn

Resolved aaelghat
(@aaelghat)

10 years, 3 months ago

Hi! I have a Google Sheet where I use the Hyperlink function (I pass a link, and link text). In the Google sheet as displayed on Google, that results in a clickable link. However, even if I have the linkify attribute set, the value does not show the link when I embed the sheet with the plugin – it just shows the value as text, and it’s not clickable.

Is there a way around that? Thanks in advance!

https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author Meitar
(@meitar)

10 years, 3 months ago

Sigh, this post is “sticky,” literally at the top of the support forum: https://ww.wp.xz.cn/support/topic/how-to-enable-html-in-the-inline-google-spreadsheet-viewer

Thread Starter aaelghat
(@aaelghat)

10 years, 3 months ago

OK, I see that the sticky post linked to another post, which said Hyperlink wasn’t supported because Google didn’t export the link.

Indeed, I added the code to my functions.php and the hyperlinks from the HYPERLINK function did not come through.

Thanks for the response.

Plugin Author Meitar
(@meitar)

10 years, 3 months ago

I see that the sticky post linked to another post, which said Hyperlink wasn’t supported because Google didn’t export the link.

[…]

the hyperlinks from the HYPERLINK function did not come through.

Because google does not export a hyperlink. Use HTML, not Google Sheets formulas, if you want links. I can tell you the answer three times but I can not make you understand it, you need to do that part.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Google Sheets Hyperlink Functiin’ is closed to new replies.

3 replies
2 participants
Last reply from: Meitar
Last activity: 10 years, 3 months ago
Status: resolved