Solved

Hover Cell For Image (Google Sheets)

Posted on 2016-08-16
5
78 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
  • 2
  • 2
5 Comments
 
LVL 8

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 8

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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