Changing the Anchor of an Image

Images are inserted in a Calc spreadsheet anchored to cells by default and do not resize when the cell is moved.

Images can be anchored in three different ways:

To Change the anchor of an image

Select the image and choose Format - Anchor, or, on the context menu of the image choose Anchor


The original size of the image and cell is preserved while pasting the entire row or entire column for both To Cell and To Cell (resize with cell) options.