[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142063

--- Comment #4 from tking.6 at juno.com ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210916/e3fb758a/attachment.htm>