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 Cell: the image will move along with the cell, when copying, sorting or inserting and deleting cells above and on the left of the cell holding the anchor.
To Cell (resize with cell): the image will move along with the cell. In addition, the image height and width will be resized if the cell holding the anchor is later resized. The aspect ratio of the image follows the later aspect ratio of the cell holding the anchor.
To Page: the image position in the page is not affected by cells ordering or cells movements.
Select the image and choose, or, on the context menu of the image choose
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.