Today all pictures inserted to Calc is anchored to page.
However, when a range containing the graphic is sorted manually (Data | Sort) and the rest of the row moves, the graphic remains fixed at the same location.
This holds true whether Protect Position is set or not, and whether the graphic is inserted as a link or not.
I can confirm that this bug is also found in 22.214.171.124 on both Windows 8 and Ubuntu 14.04 64-bit.
Although it only cost me a couple of minutes in extra work, I'm still
For the home user or children in school, this bug is quite easily discoverable since those users are more likely to paste in pictures, clipart or similar.
As much as the bug is quickly encountered, it also equally requires very frequent corrections to the document to work around it. Every single time any data is modified (wrap/nowrap, additional lines added or removed, additional rows added or removed) , all images below the affected row have to move up or down, accordingly. **There's no single one-time workaround but instead constant and frequently re-occurring re-adjustment of pictures.
This quickly turns into a major annoyance for anyone, even the expert user and only the latter will even consider filing a bug report. The rest will quickly depart for any other spreadsheet application which supports sane treatment of in-cell images.
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7