[libreoffice-users] Calc: Poor handling of graphics anchored to cells

I have created a spreadsheet as a rudimentary parts database.

One column is devoted to photographs of each part. If I copy a graphic from
Windows Preview or other graphics program, select  cell, and then paste
into it, the anchor of the graphic is to the cell one left and one up from
the target cell, i.e. the diagonal cell.

If I select a cell and import a graphic file into it, the top LH corner of
the graphic coincides with that of the cell. I then resize the graphic to
fit it. But the graphic is anchored to the *page* not the selected cell, so
I have to right-click the selected graphic and choose Anchor > To Cell.

If a cell is *selected*, is it too much to expect that an imported or
pasted graphic will be anchored to the cell? Does anybody know how to make
the graphic anchor to the target cell without further fiddling?

From time to time I select one or more rows to paste into another tab in
the spreadsheet to make a purchase order or an invoice. Because the row and
column boundaries in the new grid are evenly spaced, the graphics distort
and become vertically elongated. Typically the anchor also moves to the
cell diagonally upper and left of the home cell too. Or the anchor moves to
the cell above or below.

After experimenting with resizing the row and column boundaries of a cell
containing a graphic, it appears that a graphic squashes along one axis
when the size of that dimension becomes less than the dimension of the
graphic. Is there some setting that allows a graphic to stay anchored to
its home cell and remain at its size while the row and cell dimensions are
fixed up?

Why can't graphics resize proportionally when the cell dimensions change?
Why can't anchors stay in one place? If you wanted to move an anchor, you
could click on the graphic to make the anchor visible, then drag the anchor
to where you wanted it to go.

Has anyone else suffered this behaviour? It's hard to believe graphics
positioning in mature software could continue to be this bad.

Regards,
Hedley



-- 
Unit 2, 15 Allambee Avenue, Camberwell VIC 3124, Australia
hedley.finger@gmail.com<https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=hedley.finger@gmail.com>
Telephone 03 9836 4635
Mobile 0412 461 558

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted