Bug 108994 - FILESAVE: XLS: Shapes lost after Roundtrip
Summary: FILESAVE: XLS: Shapes lost after Roundtrip
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
4.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, filter:xls, regression
Depends on:
Blocks: Shapes XLS
  Show dependency treegraph
Reported: 2017-07-07 03:46 UTC by yoshioka digo
Modified: 2022-10-02 18:48 UTC (History)
3 users (show)

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

office products auto shape issue (212.77 KB, application/zip)
2017-07-07 03:54 UTC, yoshioka digo
Some shapes lost after saving to .xls (10.14 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-14 15:49 UTC, Xisco Faulí
Original XLS (35.00 KB, application/vnd.ms-excel)
2020-09-29 12:47 UTC, Timur
Original XLS saved in MSO as XLSX (13.33 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-09-29 12:48 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description yoshioka digo 2017-07-07 03:46:12 UTC
When office 2003 files are converted to office 2007 and Libreoffice functions are applied and saved with office 2007 format, size of some auto shapes like {,}, block arrows get changed to much smaller shape than earlier.

Steps to Reproduce:
1.Save the .xls file having auto shape to .xlsx file 
2.xlsx file again saved back in xls format.
3.The auto shapes such as braces, block arrow size gets changed to much smaller shape.

Actual Results:  
size of some auto shapes like {,}, block arrows get changed to much smaller shape than earlier.

Expected Results:
auto shape size should not change.

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 yoshioka digo 2017-07-07 03:54:37 UTC
Created attachment 134523 [details]
office products auto shape issue
Comment 2 Xisco Faulí 2017-07-14 15:49:16 UTC
Created attachment 134631 [details]
Some shapes lost after saving to .xls
Comment 4 Xisco Faulí 2017-07-14 16:06:40 UTC
not happening when saving to .XLSX
Comment 5 Buovjaga 2018-06-14 15:22:49 UTC
Sadly the problem is already in the oldest commit of Win bibisect repo 44
Comment 6 Timur 2020-09-29 12:47:18 UTC
Created attachment 165945 [details]
Original XLS

Since attachment is zipped (not a good practice), here is original XLS.
Comment 7 Timur 2020-09-29 12:48:30 UTC
Created attachment 165946 [details]
Original XLS saved in MSO as XLSX

Since bug is about saving XLSX to XLS, here is MSO saved XLSX.
Bug is: save this XLSX in LO as XLS. 
Repro 7.1+.
Comment 8 QA Administrators 2022-09-30 03:52:18 UTC Comment hidden (obsolete)
Comment 9 Roman Kuznetsov 2022-10-02 18:48:52 UTC
No rerpo in

Version: (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded

Let's close this one as WFM