Bug 165406 - FILESAVE XLS with form controls roundtripped as XLSX not opening in Excel
Summary: FILESAVE XLS with form controls roundtripped as XLSX not opening in Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (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, implementationError
Depends on:
Blocks: XLSX-Corrupted XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2025-02-23 16:40 UTC by Aron Budea
Modified: 2025-11-10 18:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample XLS #1 (20.00 KB, application/vnd.ms-excel)
2025-02-23 16:40 UTC, Aron Budea
Details
Sample XLS #2 (73.50 KB, application/vnd.ms-excel)
2025-02-23 16:40 UTC, Aron Budea
Details
Sample XLS #3 (27.00 KB, application/vnd.ms-excel)
2025-02-23 16:41 UTC, Aron Budea
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2025-02-23 16:40:02 UTC
Created attachment 199402 [details]
Sample XLS #1

This issue is related to bug 164141, originating after the fix in bug 106181, but not resolved with the additional fix in bug 164141.

To reproduce, save either of the attached XLS samples as XLSX, and try opening them in Excel.

=> Excel fails to open the XLSX, and when attempting repair, shows similar error:
Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)

This happens since the following commit in 7.0 (and its backport in 6.4). It's not a regression, since previously this content was simply lost on export.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=fd238380ae7820f12ac1f7c52d0f7180a93f3ba3
https://git.libreoffice.org/core/commit/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 Aron Budea 2025-02-23 16:40:46 UTC
Created attachment 199403 [details]
Sample XLS #2
Comment 2 Aron Budea 2025-02-23 16:41:22 UTC
Created attachment 199404 [details]
Sample XLS #3
Comment 3 Justin L 2025-11-10 16:59:13 UTC
The attachments from comment 0 and comment 1 seem to be fixed in 26.2 master.
I can still reproduce Excel 2010/2024 complaining about comment 2's forum-mso-en4-30000.xls.
Comment 4 Justin L 2025-11-10 18:27:22 UTC
(In reply to Justin L from comment #3)
> I can still reproduce Excel 2010/2024 complaining about comment 2
It doesn't like the unescaped '&' in drawing1.xml's
  <a:t>IVR & APAC Numbers</a:t>
Comment 5 Justin L 2025-11-10 18:52:04 UTC
(In reply to Justin L from comment #4)
> It doesn't like the unescaped '&' in drawing1.xml's

Already fixed by commit 196b3fe18948b1c6b6afe78d171a62513bc21980
Author: Noel Grandin on Wed Nov 5 10:58:49 2025 +0200
    mso-test: escape text of a:t element