Bug 119046 - FILESAVE XLSX ActiveX Controls created with Excel are lost when saved as XLSX
Summary: FILESAVE XLSX ActiveX Controls created with Excel are lost when saved as XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
: 139357 (view as bug list)
Depends on:
Blocks: XLSX-ActiveX
  Show dependency treegraph
 
Reported: 2018-08-01 16:17 UTC by Gabor Kelemen (allotropia)
Modified: 2022-09-02 04:39 UTC (History)
4 users (show)

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


Attachments
Example file from Excel with 11 ActiveX controls (43.57 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 16:17 UTC, Gabor Kelemen (allotropia)
Details
The example file saved by Calc 6.2alpha (10.75 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 16:17 UTC, Gabor Kelemen (allotropia)
Details
The two files opened in Calc (98.08 KB, image/png)
2018-08-01 16:19 UTC, Gabor Kelemen (allotropia)
Details
New style form controls from Excel (26.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 16:28 UTC, Gabor Kelemen (allotropia)
Details
New style form controls from Excel - saved by LO 6.2master (10.75 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 16:28 UTC, Gabor Kelemen (allotropia)
Details
The two form control containing files opened in Calc (104.30 KB, image/png)
2018-08-01 16:31 UTC, Gabor Kelemen (allotropia)
Details
Screenshot of the original document and its saved version side by side in Calc (61.85 KB, image/png)
2020-10-05 06:55 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2018-08-01 16:17:00 UTC
Created attachment 143904 [details]
Example file from Excel with 11 ActiveX controls

ActiveX controls are lost when a spreadsheet created with Microsoft Excel is opened in LibreOffice Calc and saved as XLSX.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Insert an ActiveX control.
4. Save the file as XLSX and close it.
5. Open the file in LibreOffice Calc.
6. Save the file as XLSX with Calc.
7. Reopen the spreadsheet in Calc or Excel.

Actual results:
The ActiveX controls are lost.

Expected results:
The ActiveX controls should be still in the spreadsheet.

Version: 6.2.0.0.alpha0+
Build ID: 921f285c7ff713ad219d3e3385d7e7d12d33581e
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: hu-HU (hu_HU); Calc: CL
Comment 1 Gabor Kelemen (allotropia) 2018-08-01 16:17:57 UTC
Created attachment 143905 [details]
The example file saved by Calc 6.2alpha
Comment 2 Gabor Kelemen (allotropia) 2018-08-01 16:19:14 UTC
Created attachment 143906 [details]
The two files opened in Calc

Import works rather decently, but export is a non-feature.
Comment 3 Gabor Kelemen (allotropia) 2018-08-01 16:28:16 UTC
Created attachment 143907 [details]
New style form controls from Excel

For completeness, this file contains the set of new style form controls supported by Excel.
Comment 4 Gabor Kelemen (allotropia) 2018-08-01 16:28:59 UTC
Created attachment 143908 [details]
New style form controls from Excel - saved by LO 6.2master
Comment 5 Gabor Kelemen (allotropia) 2018-08-01 16:31:00 UTC
Created attachment 143909 [details]
The two form control containing files opened in Calc
Comment 6 Gabor Kelemen (allotropia) 2018-08-01 16:37:05 UTC
This was detected by my team and still happens with a week old version from bibisect-win32-6.2 repo.
Comment 7 QA Administrators 2019-10-12 02:43:21 UTC Comment hidden (obsolete)
Comment 8 NISZ LibreOffice Team 2020-10-05 06:55:35 UTC
Created attachment 166077 [details]
Screenshot of the original document and its saved version side by side in Calc

Still a problem in:

Version: 7.1.0.0.alpha0+ (x64)
Build ID: dda71436b8594fb0669b3ac06c02a3997a0674be
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 9 m.a.riosv 2021-01-02 01:32:38 UTC
*** Bug 139357 has been marked as a duplicate of this bug. ***