Download it now!
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
Depends on:
Blocks: XLSX-ActiveX
  Show dependency treegraph
 
Reported: 2018-08-01 16:17 UTC by Gabor Kelemen
Modified: 2020-10-05 06:55 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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
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
Details
The two files opened in Calc (98.08 KB, image/png)
2018-08-01 16:19 UTC, Gabor Kelemen
Details
New style form controls from Excel (26.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 16:28 UTC, Gabor Kelemen
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
Details
The two form control containing files opened in Calc (104.30 KB, image/png)
2018-08-01 16:31 UTC, Gabor Kelemen
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 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 2018-08-01 16:17:57 UTC
Created attachment 143905 [details]
The example file saved by Calc 6.2alpha
Comment 2 Gabor Kelemen 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 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 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 2018-08-01 16:31:00 UTC
Created attachment 143909 [details]
The two form control containing files opened in Calc
Comment 6 Gabor Kelemen 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