Bug 164141 - XLS roundtripped as XLSX not opening in Excel
Summary: XLS roundtripped as XLSX not opening in Excel
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx
Depends on:
Blocks: XLSX-Corrupted XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2024-12-03 10:40 UTC by Timur
Modified: 2025-01-29 12:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2024-12-03 10:40:35 UTC
This is a followup of bug 163842 where XLSX>XLSX was fixed so for XLS>XLSX.

Sample files can be opened in Excel in their current state.
Open them in LO, save them as XLSX, and try opening them in Excel.

=> Excel is unable to open the files, and shows error message:
Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)
Repaired Records: Drawing from /xl/drawings/drawing2.xml part (Drawing shape)

Samples are attachment 197536 [details] and attachment 197537 [details].


Regressed from the following commit in 7.0:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=fd238380ae7820f12ac1f7c52d0f7180a93f3ba3
author		Serge Krot <Serge.Krot@cib.de>	2020-05-13 22:52:52 +0200
committer	Thorsten Behrens <Thorsten.Behrens@CIB.de>	2020-05-26 00:20:54 +0200
tdf#106181 XLSX export: output form controls
Comment 1 Roman Kuznetsov 2024-12-03 11:34:02 UTC
Confirm in

Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 94afced0195ef824e575176e33c79ca57484cd5c
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded
Comment 2 Aron Budea 2024-12-10 04:20:10 UTC
(In reply to Timur from comment #0)
> This is a followup of bug 163842 where XLSX>XLSX was fixed so for XLS>XLSX.
To clarify, that turned out to be a different issue in the end.

> Regressed from the following commit in 7.0:
The fundamental issue / missing feature seems to be LO not supporting the export of form controls. Previously they got lost on save, and after the change the file gets corrupted. Even if this is still unsupported, would be good to at least return to the state where files didn't get corrupted.
Comment 3 Timur 2024-12-11 15:09:29 UTC
This is related or the same as bug 136397 but so far See Also is enough.
I prefer to have file shown as corrupted than to silently lose data.
Comment 4 Szymon Kłos 2025-01-22 11:56:04 UTC
(In reply to Timur from comment #3)
> This is related or the same as bug 136397 but so far See Also is enough.
> I prefer to have file shown as corrupted than to silently lose data.

Just idea for future: even better would be to warn user before/during saving.
So it will not be a suprise when opening the file again.
I don't know if we have similar workflow already in LO.