Bug 124203 - FILESAVE XLSX: no auto-run macro after round-trip, VBA error running "For Each ws In ThisWorkbook.Worksheets" after roundtrip
Summary: FILESAVE XLSX: no auto-run macro after round-trip, VBA error running "For Eac...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2019-03-19 10:51 UTC by C Buffey
Modified: 2022-09-25 03:13 UTC (History)
6 users (show)

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


Attachments
Macro enabled excel (531.76 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2019-03-19 11:05 UTC, C Buffey
Details

Note You need to log in before you can comment on or make changes to this bug.
Description C Buffey 2019-03-19 10:51:09 UTC
Description:
Hi

I have created a document in Excel which contains macros. 
I have give copies of these files to all my staff, some of whch are using the latest version of libreoffice (March 2019) 

The original file can be opened, and with the security set to low, use the file with all the macros and active x commands.

After using the file, it is saved as "Excel 2007 - 2019 macros enabled"

When I try to open the file again, either in Libre office calc or Excel 2013, the file opens but none of the macros or active x commands work.


Steps to Reproduce:
1.Open Excel macro enabled file in Libre office
2.Edit
3.Save as Excel 2007 - 2019 macros enabled
4.Exit document
5.Re-open document in Excel or Libreoffice

Actual Results:
File opens but macros and active x commands not executed. 
All date is saved and accessible.

Expected Results:
All macros and Active x commands should work


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 C Buffey 2019-03-19 11:05:12 UTC
Created attachment 150097 [details]
Macro enabled excel

Here is the template that we are using, created in Excel 2007 & 2013.

This is then edited and saved in libre office as a "Excel 2007 - 2019 macros enabled". 

I noticed that the file size increases from around 500kb to 3,500kb (not sure if that has any significance, but thought it was worth mentioning)

When reopened in Excel or Libreoffice the macros and active x commands stop working.
Comment 2 raal 2019-05-26 07:29:40 UTC
I can confirm with Version: 6.3.0.0.alpha1+
Build ID: 38ac0586448d4f07811b139f62f62686b029feba
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 

after resave, all sheets are set as hidden and on sheet "Home page" are all buttons missing
Comment 3 raal 2019-05-26 07:33:37 UTC
In Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 
buttons are lost after resave; macro doesn't works in original version
Comment 4 QA Administrators 2021-05-26 04:53:10 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2021-06-09 16:29:51 UTC
still repro in

Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 31ed81ea71a20ec119805f66a42f99b3f80d2dc5
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded
Comment 6 Justin L 2022-09-23 23:00:53 UTC Comment hidden (obsolete)
Comment 7 Justin L 2022-09-25 02:45:07 UTC
repro 7.5+
On open, the original file nicely unhides all sheets automatically, and the macros behind various buttons seem to work.

Two immediately seen problems here after a save and reload.
"AAA Calendar TEMPLATE.xlsm" REALLY depends on having  Workbook_Open run on startup. Auto-run doesn't happen on the round-tripped file.

Secondly, on the round-trip we get an error with
  For Each ws In ThisWorkbook.Worksheets
while on the original document it runs fine. Why?