Locking inserted images in place

Discuss the spreadsheet application

Locking inserted images in place

Postby nbrettoner » Tue Mar 30, 2010 2:49 am

Hi,

Using Calc 3.2 OOo & am having problems with columns of thumbnail images staying in place, & being anchored to their respective cells.

I have created 2.5cm x 2.5cm thumbnail images which I wish to place into spreadsheet docs.
The spreadsheet's "image" column's cells I set up to 2.5cm x 2.5cm; to match thumbnail size.
Each inserted image I select to anchor to cell. This is already the program's default setting.

Firstly, I note that if I edit the image after placement in Calc, it shows as 2.49cm square.
After placing say twenty or so in a column, they tend to creep up. Even resizing them in calc does not help.
I have to fine-tune each one, to get it with it's cell. After several more, the anchor marker moves up to the above cell.

In addition to this problem, if I create a new sheet (top line of column headings are frozen) the same as 1st sheet, then continue on placing thumbnails, the anchor starts off in the adjacent cell!; to the left!.
Nothing I've tried so far has helped in getting the images to locate correctly in it's cell, nor the anchor to be necessarily attached to that cell.

I have attached a screen-grab of my problem. You will note the image inserts higher up than it should, & the anchor is to the wrong cell.

Help please!

I have read several forum responses concerning similar problems, but I'm hopeful someone may be able to make life a whole lot less tedious & enjoyable for me. I have several spreadsheets & thousands of images to collate & document.
Unfortunately they cannot be processed in any sort of methodical timeline/location/topic order. Hence the need for a spreadsheet system, to aid further sorting as above. :)
Attachments
Clipboard01.jpg
screen shot of image location problem
kind regards,

Noel B.
OOo 3.2
XP sp3
nbrettoner
 
Posts: 4
Joined: Tue Mar 30, 2010 2:15 am
Location: Coffs Harbour NSW Australia

Re: locking inserted images in place

Postby ken johnson » Tue Mar 30, 2010 7:51 am

Calc cannot handle images. They will not move from there current cells when you do a sort.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: locking inserted images in place

Postby nbrettoner » Tue Mar 30, 2010 8:07 am

Hi Ken,
Thanks for your quick response.

If the image is inserted into a note attached to a cell, would that note (& image) move with the cell when sorted?.
Also please, what happens to web links inserted into cells (when a sort is done)?? :)
kind regards,

Noel B.
OOo 3.2
XP sp3
nbrettoner
 
Posts: 4
Joined: Tue Mar 30, 2010 2:15 am
Location: Coffs Harbour NSW Australia

Re: Locking inserted images in place

Postby ken johnson » Wed Mar 31, 2010 6:07 am

Hi Noel,
nbrettoner wrote:If the image is inserted into a note attached to a cell, would that note (& image) move with the cell when sorted?

I had a go at doing it this way and it seems to work quite well with sorting. Filtering isn't satisfactory unless "Show Comment", accessed via the cell's right-click contextual menu, is deselected (In OOo 3.2 Notes are now called Comments). The comments attached to the hidden rows are not also hidden.
nbrettoner wrote:Also please, what happens to web links inserted into cells (when a sort is done)??

As far as I can tell web links sort OK.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: Locking inserted images in place

Postby nbrettoner » Wed Mar 31, 2010 6:18 am

Hi Ken,

Many thanks for your comments & quick response with this. :D

I am processing several hundred old negatives & photographs, stretching back 100 years.
They are our grandparent's & father's, & as all the people in them (excepting a very few) are deceased, there's no-one to ask.

I am digitally photographing each image just as I find them. Yes there is a modicum of order, but many are mixed up.
Of course any in albums are fairly well ordered 'though.

Because I cannot firstly go through them all & place in a logical order, we had decided to record them together with their thumbnail images into spreadsheets.
The intention being; to collate as much info as is possible, then group & place in some sort of logical order & finally create a new set of number systems for the various groups. Hence using spreadsheets.
So it's imperative that the thumbnails stick with their respective cells!
kind regards,

Noel B.
OOo 3.2
XP sp3
nbrettoner
 
Posts: 4
Joined: Tue Mar 30, 2010 2:15 am
Location: Coffs Harbour NSW Australia

Re: Locking inserted images in place

Postby ken johnson » Wed Mar 31, 2010 8:32 am

Hi Noel,
Sounds like a lot of work.
Hope it all works out well.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: Locking inserted images in place

Postby RoryOF » Wed Mar 31, 2010 8:35 am

There is an extension that allows addition of images to a Base project.
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: 30439
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Locking inserted images in place

Postby Villeroy » Wed Mar 31, 2010 9:52 am

There is a database component which treats images as "cell values".
Open the input form in pictures.odb.

Inserting Megabytes of pictures in Base is not recommended though due to some technical shortcomings in Base. Since v3 it is possible to link picture controls to a text column of relative path names pointing to picture files.
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: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Locking inserted images in place

Postby nbrettoner » Wed Mar 31, 2010 10:58 pm

Thanks RoryOF Villeroy & others for your valued advice. :)

Tomorrow I hope to start experimenting, to see what can be done.
Being somewhat sketchy on database setup etc means I may take awhile to 'get it', then apply. :? :)

However, armed with the advice so far, I shall persevere. :crazy:
Hope to report back here once I have a workable solution running.
:D
kind regards,

Noel B.
OOo 3.2
XP sp3
nbrettoner
 
Posts: 4
Joined: Tue Mar 30, 2010 2:15 am
Location: Coffs Harbour NSW Australia

Re: Locking inserted images in place

Postby osc » Mon Jan 20, 2014 8:48 am

ken johnson wrote:Calc cannot handle images. They will not move from there current cells when you do a sort.

Ken Johnson



Is this still true? version 3.5 or 4.2?
LibreOffice 3 on Mint 13
osc
 
Posts: 2
Joined: Tue Dec 31, 2013 7:09 am

Re: Locking inserted images in place

Postby acknak » Mon Jan 20, 2014 1:48 pm

osc wrote:... Is this still true? version 3.5 or 4.2?

Yes, unfortunately.

Calc can anchor an image to a particular cell, but that's just a location relative to the spreadsheet grid. The image is not contained in the cell and it won't move with the cell content.
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: No registered users and 8 guests