https://bugs.documentfoundation.org/show_bug.cgi?id=142063
--- Comment #4 from [email protected] --- I experienced the same problem after upgrading to 7.1.5.2. Sheets with macros that I had used for years no longer loaded the macros associated with the spreadsheet. The ones under MYMACROS were still there but don't run from there. They have to be attached to the spreadsheet. After a lot of testing, saving the file as .ODS, that retained the macros when the sheet is reloaded. To verify, open LO calc (it will be named Untitled 1): go to Tools: Scroll down to Macros: select Edit Macros: Click on Untitled 1: The item Standard will appear below Untitled: Go to the row of icons and click on the one next to the question mark (Modules): Make sure the window on the 3rd row contains Untitled: Position the cursor on the word Standard: Click the New button: A new module window will appear: Click its OK button: Module 1 will now appear below Standard: A window will open showing a Sub Main line and an End Sub line. Click Save under file and save as an .XLS file: Now open the sheet, go to Tools, select Macros, edit Macros, and Click on Untitled 1, then Standard, the macro will be gone. Rebuild the macro by clicking on the Module icon next to the question mark (same steps as above). Go to File and select Save As an .ODS sheet. Close the sheet. Reload it and go to Tools and Macros: Edit Macros and scroll through the selections and the macro will there. More testing revealed that spreadsheets created prior to 7.1.5.2 work correctly. After I loaded 7.1.5.2, my macros in .XLS files don't load. Based on this, there is a setting in .XLS saves / loads that is not being processed properly or there is some missing code associated with 7.1.5.2 that handles .XLS saves / loads. I'm running W10 home. -- You are receiving this mail because: You are the assignee for the bug.
