Photo fitting to fill cell?

Discuss the spreadsheet application
Post Reply
mmi
Posts: 1
Joined: Tue Feb 19, 2019 1:28 am

Photo fitting to fill cell?

Post by mmi »

hello
have searched and didnt find an answer
as you all are aware MS has left most of us with corrupted or inoperable files.
when someone suggested apache I started to rebuild my excel lists, there are a few minor functions I would like to adjust in those at some point

but for today was working on a companion photo list, I may be using the wrong application of excel for this ? better option?
photo managers dont work

started with excel, have my cells/columns rows set out ,and it was working but I have 3 questions that would make it a lot cleaner.
1 ...how can I replicate cell template by groups of 5 (full page)rows columns /70 cells
2 how can I insert photo/picture (700 cells) and have it fit the cell with out trying to drag and match
3 (this may include starting with another option?) if I need to add a new item photo (insert new cell)to position (#125 row 17 column d)is there a method to make cell #126 >and beyond simply move down?
thank you
open office 4.1.6 window xp
User avatar
Zizi64
Volunteer
Posts: 11361
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: photo fitting to fill cell?

Post by Zizi64 »

The photos inserted into a Calc document are not located IN a cell, even they are not located on the layer of the cells. They are located on a graphical layer, and the only one connection between the layers is the ANCHOR.
Of course you can write a macro the align pictures virtually to the cells. There are macro code snippets for this task in this forum too.

viewtopic.php?f=9&t=34544&p=158333
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Post Reply