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.
