Bug 46871 - [FORMATTING] Anchor images as a character
Summary: [FORMATTING] Anchor images as a character
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2012-03-02 01:04 UTC by Nicolas Mailhot
Modified: 2017-12-19 16:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Mailhot 2012-03-02 01:04:11 UTC
Unlike writer, calc does not allow inserting images as a character, which makes it impossible to make sure an image stays inside a particular cell, the cell stays big enough for the image, or the image is positionned in a particular position (right left middle top bottom) of the cell
Comment 1 ign_christian 2013-06-26 05:17:14 UTC
Tried to insert picture to Calc, that picture stayed in previously selected cell (before did insertion) on the upper left part of the picture. We can also anchor to cell.

Tested on LO (Win7 32bit)

Please REOPENED this bug report if you don't agree & please provide detailed steps to show the problem (along with screenshot which is expected)
Comment 2 Nicolas Mailhot 2013-06-26 07:27:19 UTC
What was requested was to have an image anchored as character like in writer so all text positioning rules apply to the image and, like text, it can not escape the cell and all the controls that trigger when a cell is smaller than its content apply.

It is true that calc is able to fake insertion at the right point via cell anchoring at insertion time. However that is not the same thing at all, and when the document lives a cell anchoring does not behave like text insertion and as soon as cell size changes cell anchoring breaks big time
Comment 3 Joel Madero 2014-11-06 22:05:45 UTC
Needs independent confirmation by QA - moving to UNCONFIRMED.
Comment 4 sophie 2014-12-18 15:36:39 UTC
Hi, if you protect the position of the picture (right click > position and size > protect) it won't move from the cell/page it is anchored to. Cells are data container, that's not the case for Writer. Closing as Worksforme - Sophie
Comment 5 Jérôme Borme 2016-10-08 13:16:19 UTC
(In reply to sophie from comment #4)
> Hi, if you protect the position of the picture (right click > position and
> size > protect) it won't move from the cell/page it is anchored to.

Drawback is that the cell size does not adapt to the image size. The user must adjust the width of cell to match the size of the image. This requires manual work and prevents the use of Optimal height (width) for the row (column, resp.).
Comment 6 abergmeier 2017-09-09 20:03:29 UTC
I really do not understand how you close this as Worksforme.
This is a feature that works on Microsoft Office.

The necessity for this arises by things like sorting cells, where the image stays in place, although anchored at cell.