Description: After an upgrade of LibreOffice, the macros created in Calc under My Macros, Standard, Module 1 are no longer available. Steps to Reproduce: 1.Create Macro in Calc for Module 1, Standard, My Macros, save and exit 2. Restart and Update LibreOffice, exit and shutdown 3.Restart, Open file containing Macro and under tools, Macros, run Macros, look for Macro name that is now missing Actual Results: no macros Expected Results: Macros should be available Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.6.2 (x64) / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Does Reproducible mean you tried with the new simple macro or only with your specific macro ? Did you assign it to some event? You should try User Profile Reset via rename to keep it, since you will loose macros, copy them beforehand. If problem persists, you should attach here macro content and try run without assigning macro.
The macro is any simple recording: I used an existing spreadsheet, and a “copy cell input from one cell and paste it into another” as a test. After “Stop recording” I named the macro “test”. It was in the library “My Macros, standard, module 1”. As long as I didn’t shut the computer off, the macro was available to run when I opened the spreadsheet. Next, I exited Libre, and closed windows 10…..then turned off the power to the computer. I restarted the computer, opened Libre App and loaded the spreadsheet. I subsequently went to “tools, Macros, run macro. When the library’s dialog opens, “My Macros “ is present as well as “Standard”. “ Module 1” is missing as well as the saved macro “Test”. This is repeatable every time. I have not yet tried to reset the user profile, though I’m at a loss as to why I would need to do that.. I will try it going forward
[Automated Action] NeedInfo-To-Unconfirmed
That bug is not general, there's some catch. If you run macro manually, maybe sheet has filtered rows? That's why I asked you to attach it, deleting all private data and making minimal sample. Also, reset of user profile can be done in different ways, I prefer to rename folder %APPDATA%\libreoffice\4\user so new one will be created, and old one can be reverted.
I opened the Calc user manual and read through creating macros. Apparently, I wasn't doing it properly as the user guide instructed making the module and macro name using the "spread sheet name" when the tools-Macro dialog is opened. I was using the "My Macros" entry which was causing the problem. I made a new download of the LibreOffice software and created the macros according to the user manual and all seems to be ok now. It is unclear what exactly the "My Macros" library is used for, and there seems to be a lack of explanation. I surmised it was for writing Java based scrip macros, but that is a guess. Thanks for all the effort on my reported bug. I am glad it wasn't a bug but regret I caused you to spend time for nothing. Regards Gary LaPinsky