Description: Not a bug but a much desired feature. In Calc: default anchor to cell for everything {lines, text boxes, plots, graphics and groups} Presently, only graphics have 'cell' as default anchor. However, if a line or text is grouped with the graphic the group defaults to the anchor of the line or test which is 'page'. Even if the lines and text anchors are changed to 'cell' a group of lines, text and graphic (all now having cell anchors) will be assigned a 'page' anchor. Indeed, every edit one does to add lines or text to a group will cause it to revert to a page anchor. Steps to Reproduce: 1. fail to manually set every single object and group of objects' anchor to "cell" 2. insert or delete rows or columns 3. Actual Results: For all column and row indexes greater than those changed the layout is scrambled for all objects not anchored to cell. Expected Results: To work like Excel where everything is anchored to cell. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
MSO Excel has "Move and size with cells" active by default for charts and shapes but "Move but don't size with cells" for raster graphics. Third option is "Don't move or size with cells". Not so easy to compare... (or I miss the anchor vs. Nevertheless the idea is worth to discuss. Undoubtedly it would be not acceptable to anchor charts differently. But even in case of shapes or images I believe it depends heavily on the use case what option is desired. So rather than changing the default I can imagine to offer an option similar to what has been done for Writer in bug 99646.
We discussed the topic in the design meeting. To change any default needs very good reasons. But there are scenarios for both use cases, eg. to cover cell content with a shape or to have some illustration on top of the document. And the idea to add an option to define the default is over-engineering. It makes sense for Writer but not Calc. So the verdict is WF. But as a compromise we could remember the last used option. Feel free to reopen the ticket and we change the summary respectively if you agree.