how is it done?

Topic

New Reply

hello everyone;

i am a Canadian resident.

these days, the papers show a scandal about some Senators which have abused the system reporting (and collecting) exorbitant amounts for travel and residence expenditures (the two hottest cases ar Duffy and Wallin).

the link below shows a local Toronto newspaper, showing a spreadsheet with (for me) strange features.

http://www.thestar.com/news/canada/2013/02/15/senate_finance_data.html

i believe every picture shown is a cell in the spreadsheet, and the legends are the comments.

i am assuming it’s created in Excel.

any ideas about how this was created?

i use Excel from Office 2003, and have not seem this possibility.

thanks in advance.

daniel rozenberg.

Reply | Quote

Replies

i want to clarify my question.
inserting a picture from file in cell is straightforward.
inserting a comment is a cell is also straightforward.
what i have difficulty to see is how a cell can hold simultaneously a picture and an comment.
in my attempts to create such feature have been unsuccessful.
when i place the cursor in the cell (with the picture), the comment does not show.

daniel rozenberg.

Reply | Quote

Maybe I’m missing something about your question, but I created an expanded row and column, inserted Duffy’s pic and also inserted a comment. Maybe the issue was “resolved” with an expanded row and column?

See the attached and hover the mouse over the pic. While I created it using 2010, I saved it in the compat format, so there shouldn’t be any issue.

Reply | Quote

I believe that this is not an excel spreadsheets rather HTML/XHTML coding with javascript mouseovers. If ypu highlight all the pictures and then copy them, pasting them onto a spreadsheet pastes them on top as individual images, not cells.

Reply | Quote

gentlemen,
thanks for your replies.

kweaver;
Thanks for your reply.
i got the same as you do, but my difficulty is to get the comment to pop out when the cursor is on the picture, not just above the corner of the cell.

Maudibe;

Thanks for your reply.
i put a Google for HTML/XHTML coding with javascript mouseovers; and will try to learn something about it.

thanks again to U all.

daniel rozenberg.

Reply | Quote

Daniel,
In my earlier Excel attachment, the comment does pop up when you mouse over the pic. At least, it did on my system.

Reply | Quote

Dan,

You can also make a pop out comment for the picture as well if the cell is too hidden underneath it. Right click on the picture and click on Hyperlink. In the Insert Hyperlink window select “Place in this Document on left side. In the Right upper corner, click screentip… Type your meesage for the popup. You have to be closer to the center of the pic for the popup to appear

HTH,
Maud

34305-Mouseover

Reply | Quote

Hi All

It is possible to replicate the original post in Excel.
But that would take me some time.
So instead, I have taken kweavers posted file and updated it to show an Excel mouseover as you float over the picture.
And, just for fun, I have added another image to show another version of a mouseover message box.
The code is simple and straightforward.
The technique used is not that complicated.
I will explain step by step instructions if necessary, but I am sure it won’t take too long for RG, Maud et al to explain how I did this.

zeddy

Reply | Quote

Sorry for jumping into this late but this is perfect for a project I am working on. I can use images now instead.

Zeddy- Very cool but If I counted right, are there 8 images that are used? Could you please explain?

Maudibe- Very simple. Thank you for the tip (screen tip)

KWeaver- As long as the picture is smaller than the cell I had no problem with the display

Thanks guys,
Al

Just an update: I have taken Kweaver’s idea to overlay an image inside the cell with no reworking and it works great. Thank you so much.

Reply | Quote

Hi Alouso

You are correct – there are 8 shapes in total for the two pictures, so it’s four each:
1=the picture itself; 2=the displayed note; 3=the mouseover shape to show the note; 4=the mouseover shape which hides the note

I have attached a file which shows these shapes a little clearer, for instruction purposes.

To have a ‘mouseover event’, we use the Excel Control Toolbox, select Image from the Toolbox, and create a square slightly smaller than the picture image.
(We can use the name dropdown box to give this shape a new name if we wish.)
We can right-click this shape to select Properties, and then change the BackStyle to fmBackStyleTransparent, and change property BorderStyle to fmBorderStyleNone.
This hides the shape’s border and makes it an ‘invisible’ transparent box which we can then overlay over the picture.

The MouseMove event for this shape will be used to turn on the display of the message box for this picture.
To add the code for the MouseMove event for this shape, you right-click the shape and select View Code from the right-click-menu.
This will show the VBEditor, and will show the Click event by default. In the top-right event dropdown, you can then select the MouseMove event.

When the mouse moves off the image, we want to hide the displayed message box.
So We simply use another ‘invisible’ box, slightly larger than the one used to display the message box.
We use the MouseMove event for this shape and add code to hide the message shape.

In the first post from danielr2, there are 12 images across by 9 rows of pictures, each picture of same size.
We could use the method above for each picture.
But I guess it would be possible to use a single ‘invisible’ mouseover-shape, and use the X and Y values of the mouse coordinates, in conjunction with Excel’s MOD function to determine which image the mouse is ‘over’ etc.
I did say it would be tedious to do!

zeddy

Reply | Quote