Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Testing Anchor > To Cell on LO 4.2.4.2 shows that:

  1. Upon saving and reopening the document, images will have shifted down in their cell, possibly overlapping the row below if it was initially a tight fit.
  2. If you left click on an image in a cell you will see a blue border light up. This blue border is shifted above the image. This is probably indicative of the bug that caused the image shifting.
  3. If you increase a row's height and that row already contains an image, you will notice that the image then stretches. This is very annoying.

A way to slightly alleviate Anchor > To Cell pain is to set a keyboard shortcut (Tools / Customize...). I set ctrl-shift-C to Category: Format, Function: Change Anchor. Then you can paste an image, resize it to your cell, and immediately type ctrl-shift-c to anchor it.

Unfortunately, from what I've been told, very few people are working on improving LO's user interface. Most effort is currently on LO Calc's computational engine. UI-related bug reports and feature requests seem to go nowhere, even when people have been asking them for over 10 years.

Testing Anchor > To Cell on LO 4.2.4.2 shows that:

  1. Upon saving and reopening the document, images will have shifted down in their cell, possibly overlapping the row below if it was initially a tight fit.
  2. If you left click on an image in a cell you will see a blue border light up. This blue border is shifted above the image. This is probably indicative of the bug that caused the image shifting.
  3. If you increase a row's height and that row already contains an image, you will notice that the image then stretches. This is very annoying.
  4. If you save the document to another file format, e.g. xls, the Anchor To Cell is lost. All images become Anchor To Page. Images are shifted. Very very annoying.

A way to slightly alleviate Anchor > To Cell pain is to set a keyboard shortcut (Tools / Customize...). I set ctrl-shift-C to Category: Format, Function: Change Anchor. Then you can paste an image, resize it to your cell, and immediately type ctrl-shift-c to anchor it.

Unfortunately, from what I've been told, very few people are working on improving LO's user interface. Most effort is currently on LO Calc's computational engine. UI-related bug reports and feature requests seem to go nowhere, even when people have been asking them for over 10 years.