Solved

Hover Cell For Image (Google Sheets)

Posted on 2016-08-16
5
664 Views
Last Modified: 2016-09-13
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.
0
Comment
Question by:oo7ml
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 9

Accepted Solution

by:
James Bilous earned 500 total points
ID: 41758273
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.
0
 

Author Comment

by:oo7ml
ID: 41758283
Thank you. I presumed the meant some Visual Basic script of some sort?
0
 
LVL 9

Assisted Solution

by:James Bilous
James Bilous earned 500 total points
ID: 41758300
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.
0
 

Author Comment

by:oo7ml
ID: 41759797
Thank you.

Yes, but that defeats the purpose of collaborating via a Google Sheet.
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41795667
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
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question