Bug 150248 - FILESAVE XLSX Invalid file when saving text box form control
Summary: FILESAVE XLSX Invalid file when saving text box form control
Status: NEW
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: dataLoss, implementationError
Depends on:
Blocks: XLSX-Corrupted XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2022-08-03 11:58 UTC by Gabor Kelemen (allotropia)
Modified: 2022-08-03 15:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (8.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-08-03 11:58 UTC, Gabor Kelemen (allotropia)
Details
The example file saved by current nightly (5.06 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-03 11:58 UTC, Gabor Kelemen (allotropia)
Details
The example file in current nightly and its xlsx version in Excel 2016 (114.09 KB, image/png)
2022-08-03 12:02 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2022-08-03 11:58:23 UTC
Created attachment 181559 [details]
Example file from Calc

Attached example file contains a simple text box form control.
When saved as XLSX and opened in Excel, Excel gives unreadable content error and repairs the file:
"Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)"

1. Open attached file
2. Save as XLSX, open it in Excel 

In 6.4 this control was not exported at all. Excel has the "Label" form control, which could be used as export target in this case.

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 86b2bfd34a4f07c54f03c8c8dfe48e0810834628
CPU threads: 14; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded

Bibisected to:

https://git.libreoffice.org/core/+/23506180a82bae5c77bd1df4bef73dd4f687dae2

author	Serge Krot <Serge.Krot@cib.de>	Thu Jun 04 11:14:39 2020 +0200
committer	Xisco Fauli <xiscofauli@libreoffice.org>	Mon Jun 08 12:36:37 2020 +0200

tdf#133595 FILESAVE XLSX: invalid content when opening file with shape

Just before this commit the error message given by Excel was different:
Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  Katasztrofális hiba Line 2, column 1849.
Comment 1 Gabor Kelemen (allotropia) 2022-08-03 11:58:57 UTC
Created attachment 181560 [details]
The example file saved by current nightly
Comment 2 Gabor Kelemen (allotropia) 2022-08-03 12:02:05 UTC
Created attachment 181561 [details]
The example file in current nightly and its xlsx version in Excel 2016
Comment 3 Timur 2022-08-03 15:00:08 UTC
And missing on reopen in LO for both XLSX and XLS. XLS in MSO no error but empty.