Add 170 photos via path

Discuss the spreadsheet application

Add 170 photos via path

Postby JacopoTore » Thu Nov 14, 2019 12:30 pm

Hi everyone, I have to add (as automatically as possible) about 170 photos, the photos are named like that
and I would like them to appear in cell A of each row.

I would like to create a sort of database and I need help because I'm not a professional and I don't have much time available. I am willing to pay some good soul to take this commitment <3
(I would offer my experience and professionalism in return, but I doubt anyone would need a pianist / composer :ucrazy: )
Last edited by robleyd on Thu Nov 14, 2019 1:35 pm, edited 1 time in total.
Reason: Remove Known Issues icon
OpenOffice 4.1.3 on MacOS 10.9
Posts: 1
Joined: Thu Nov 14, 2019 12:23 pm

Re: Add 170 photos via path

Postby Zizi64 » Thu Nov 14, 2019 2:07 pm

Do you want to embed the photos in a spreadsheet file? It is not the best idea...

Or do you want create hyperlinks to the photos?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Posts: 8772
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Add 170 photos via path

Postby Villeroy » Thu Nov 14, 2019 2:27 pm

Don't create a sort of database. Create a database.
Here is one: viewtopic.php?t=33534&p=153834#p153834 extract the zip, open database document, open form.

 Edit: Under MS WIndows you can create a list of file names with:
DIR /B *.jpg > pics.txt
DIR /B *.jpeg >> pics.txt
DIR /B *.png >> pics.txt 

The first command writes all file names ending with .jpg to file pics.txt creating a new file. The subsequent commands append file names with other suffices to pics.txt.
Last edited by Villeroy on Thu Nov 14, 2019 6:10 pm, edited 1 time in total.
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
Posts: 27758
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Add 170 photos via path

Postby RoryOF » Thu Nov 14, 2019 4:26 pm

A number of extensions exist to create a photo album. One of these might suit you.

Photo album extensions
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 30430
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Add 170 photos via path

Postby John_Ha » Thu Nov 14, 2019 5:35 pm

JacopoTore wrote:Hi everyone, I have to add (as automatically as possible) about 170 photos

It's only 170 photos so do it manually.

1. Resample each picture to the required size - see Tutorial.
2. Set the column widths and row height to the size required for the pictures
3. Place cursor in Cell A1 and left-click
4. Drag photo 1 to cell A1
5. Place cursor in Cell A2 and left-click
6. Drag photo 2 to cell A2 ...

Repeat for all others.

If you did not do Step 1 you will have to resize each image in the sheet.

If you use Linked images you can change the photos on the folder and the photos in the sheet will update. You can convert linked images to embedded - see Tutorial.

See [Tutorial] Some useful hints on using images for a discussion on how best to handle images in Writer - it applies to Calc too.

LO is likely to cope with images better than AOO.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 7269
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests