How to link a photo in spreadsheets?

Discuss the spreadsheet application

How to link a photo in spreadsheets?

Postby fas123ner » Fri Sep 17, 2010 12:42 pm

How can I link a photo to a cell in Open Office spreadsheets. I have an inventory list of products that I would love to attach photos to. I need to display the photo as a file instead of the actual photo. Help!!!

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
Open Office version 3.2. Windows XP. Edward L Wargo
fas123ner
 
Posts: 1
Joined: Fri Sep 17, 2010 12:36 pm

Re: Spreadsheets

Postby Hagar Delest » Fri Sep 17, 2010 12:45 pm

Hi and welcome to the forum!

Create a hyperlink pointing to the pic on your HD.

 Edit: 
fas123ner wrote:I need to display the photo as a file instead of the actual photo. Help!!!

My understanding is that it's fine to have just a link and not the display of the pic. 

Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).

Off line until 30-AUG-2020
User avatar
Hagar Delest
Moderator
 
Posts: 28920
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to link a photo in spreadsheets?

Postby acknak » Fri Sep 17, 2010 2:28 pm

I would love to hear from anyone who has tried to use images linked to the data in a spreadsheet and found it usable/useful. If so, how did you do it?

In my experience, it has always proved to be a waste of time because the images are not part of any cell. You can anchor an image to a cell, but the anchoring is purely cosmetic, and the position and size of the image "drift" as the sheet is used. Sorting or moving any of the rows and columns will completely disassociate an image from it's anchor cell.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: How to link a photo in spreadsheets?

Postby Villeroy » Fri Sep 17, 2010 2:48 pm

Re: Best Approach for Images - Store or Link?
Spreadsheets are calculators.
Databases are data stores.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28451
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to link a photo in spreadsheets?

Postby RoryOF » Fri Sep 17, 2010 3:21 pm

It is possible that the spreadsheet is being (mis)used as a table generator. If so, better to use Writer's table structures to achieve the same end. This would allow an icon sized view of the picture and a link to the full illustration.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31247
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to link a photo in spreadsheets?

Postby acknak » Fri Sep 17, 2010 4:39 pm

Oops. I just noticed (from Hagar's edited comment) that the question is how to make a hyperlink to the image file, not how to display images in a spreadsheet.

If that's all you want--a clickable link to the image file(s)--then there's no problem. You can create such a link by...

Insert > Hyperlink
[list]Type: Document (icons at left)
Path: (browse to the image file)
Text: "Image" (or whatever; empty will show the image file path)
Click "Apply["/list]

If you click on the link, OOo will hand off to whatever application is configured to handle that type of image file.

If you have a lot of images and you want to avoid the hyperlink dialog, you can paste the image file names into a column and create the links by a formula: =HYPERLINK("file://" & "path/to/your/images/" & ___; "LINK TEXT")

You should replace "___" with the cell address where the file name is stored.

Sorry for getting off-track from your question.

Whether you use the dialog or a formula, the link is textual data, which Calc can handle just fine, unlike an actual image in the sheet.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 20 guests