Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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.


Unit 2, 15 Allambee Avenue, Camberwell VIC 3124, Australia<>
Telephone 03 9836 4635
Mobile 0412 461 558

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.