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: 2024-09-02 03:14 UTC (History)
4 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 (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. ***
Comment 10 QA Administrators 2024-09-02 03:14:06 UTC
Dear Gabor Kelemen (allotropia),

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug