Hover Cell For Image (Google Sheets)

oo7ml
oo7ml used Ask the Experts™
on
Hi,

I would like to embed / insert an image into a Google Sheet cell, but i only want it to appear (pop up) when you hover over the cell (almost like the way that their Comments work... the comment box pops out when you hover over the cell).

I have contacted Google to see this is possible and they said that i would need to write custom code to do it.

Can anyone offer any advice or recommendations on this? I need to be able to share these documents (Google Sheets) with other people and i don't want them to have to download any additional tools or plugins.

Thanks in advance for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Commented:
When they said custom code they probably meant that you would need to make a small web app that emulates the spreadsheet, possibly using a table, and use JQuery / CSS to provide the hover effect.

What you are trying to do is not possible on google sheets.

Author

Commented:
Thank you. I presumed the meant some Visual Basic script of some sort?
James BilousSoftware Engineer
Commented:
There are many programming languages you can make something like this in. If it were me I would just throw the data in an html table (either statically with pure html or dynamically using, per your example, visual basic) and create a hover effect that shows the image using JQuery.

Author

Commented:
Thank you.

Yes, but that defeats the purpose of collaborating via a Google Sheet.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- James Bilous (https:#a41758273)
-- James Bilous (https:#a41758300)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial