Description: Feature Request Problem The xls or xlsx files created in Excel may have non-moveable and non-resizable shapes. When I read these files, attribute information of the shapes that are non-moveable and non-resizable is lost. In some cases, the original xls or xlsx file is corrected and returned to the creator of the original Excel file. In that case, I want to make as few changes to the original document as possible. However, due to compatibility issues with EXCEL, unintended changes are made. Steps to Reproduce: 1) Loads xls or xlsx files containing non-moveable and non-resizable shapes by CALC. 2) Save as xls or xlsx by CALC. 3) Attribute information of the shapes that are non-moveable and non-resizable is lost. Actual Results: Attribute information that is non-moveable and non-resizable is invalid in CALC. Expected Results: In CALC,an interface is provided for the shape to specify information that is non-moveable and non-resizable. Shapes that are non-moveable and non-resizable behave like EXCEL. Attribute information of shapes that are non-moveable and non-resizable can be read from xls or xlsx files by CALC. Attribute information of shapes that are non-moveable and non-resizable can be written to xls or xlsx files by CALC. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.0.0.alpha0+ (x86) / LibreOffice Community Build ID: 9df3aa7ea72d61462e430643f2a80906dce4e15b CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: threaded
Created attachment 171859 [details] non-moveable and non-resizable shape Sample of the non-moveable and non-resizable shape(xls)
(In reply to qve00761 from comment #1) Opening attachment 171859 [details] in Excel 2016, I can freely move and resize both shapes.
Created attachment 171888 [details] Shapes that do not move and resize to fit cells I'm sorry my English is inappropriate. Edit attachment 171859 [details] as follows: Left shape is moveable and resizable.(normal shapes) Right shape is non-moveable and non-resizable. (1) The width of Col A is chenged. At that time, the left shape moves to the left. (2) The width of Col C is chenged. At that time, the left shape spreads horizontally. (3) The width of Col F is chenged. (4) Insert row. At that time, the left shape goes down. (5) The hight of Row 7 is chenged. At that time, the left shape spreads vertically. Right shape does not move always. Right shape does not resize always.
Created attachment 171925 [details] Behavior of shapes when copying cells In Excel, select and copy columns B to H of attachment 171859 [details]. Paste it into a new Excel workbook. The moveable and resizable shape is copied. However, the non-moveable and non-resizable shape is not copied. I hope it implements features similar to Excel.
(In reply to qve00761 from comment #3) > Created attachment 171888 [details] > Shapes that do not move and resize to fit cells > > I'm sorry my English is inappropriate. > > Edit attachment 171859 [details] as follows: > > Left shape is moveable and resizable.(normal shapes) > Right shape is non-moveable and non-resizable. > > (1) The width of Col A is chenged. > At that time, the left shape moves to the left. > > (2) The width of Col C is chenged. > At that time, the left shape spreads horizontally. > > (3) The width of Col F is chenged. > > (4) Insert row. > At that time, the left shape goes down. > > (5) The hight of Row 7 is chenged. > At that time, the left shape spreads vertically. > > Right shape does not move always. > Right shape does not resize always. Testing with office.com and LibreOffice, the result is the same, so looks like the compatibility was implemented already. Arch Linux 64-bit, X11 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b693d19884a09b5f841b30f2e8b586778584ed16 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 6 October 2023