Description: Adding a sheet in front of a sheet with a narrow column width, the object anchored by the cell will move to the left. Steps to Reproduce: 1. Start Calc 2. Make the Columns [A:E] narrow. (One character can be displayed) 3. Place PushBotton control in Cell [F1]. 4. Set the PushBotton anchor to the Cell. 5. Create a new Sheet in front of the Sheet. Actual Results: It looks like PushBotton has moved to the left. Expected Results: PushBotton does not move as it is. Reproducible: Always User Profile Reset: No Additional Info: Even if there is a problem, Return to the original location by one of the following operations. ･ Operate column width or row height. ･ Delete the added Sheet. ･ The file is reopened. Objects that can be anchored Cells seem to include such problems. If there is a Sheet behind the corresponding Sheet, there will be no problem. If there is set the PushBotton anchor to the Sheet, there will be no problem.
Created attachment 179909 [details] sample file (include basic macro)
For me, the object¹ remains in the same place, but becomes invisible. If do you select it,² and change the zoom level, it reapears. ¹ I tested with a shape in cell F1 ² I created a new shape, selected the new shape, and pressed TAB. Version: 7.1.8.1 (x86) / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: en-US Calc: threaded
Confirmed with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f4ef5435df5560e6b6b061ce4053c71e2819bf51 CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded