Results 1 to 10 of 10

Thread: how is it done?

  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    how is it done?

    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/2...ance_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.

  2. #2
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    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.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    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.
    Attached Files Attached Files

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 648 Times in 591 Posts
    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.
    Last edited by Maudibe; 2013-07-02 at 22:01.

  5. #5
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    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.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Daniel,
    In my earlier Excel attachment, the comment does pop up when you mouse over the pic. At least, it did on my system.

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 648 Times in 591 Posts
    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

    Mouseover.png

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    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
    Attached Files Attached Files

  9. #9
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts
    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.
    Last edited by Alouso; 2013-07-07 at 23:34.

  10. #10
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    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
    Attached Files Attached Files

  11. The Following User Says Thank You to zeddy For This Useful Post:

    Alouso (2013-07-13)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •