[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |INSUFFICIENTDATA --- Comment #10 from Buovjaga --- No macro samples provided, so let's close -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Lew <82...@proton.me> changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #9 from QA Administrators --- Dear Lew, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||ilmari.lauhakangas@libreoff ||ice.org Ever confirmed|0 |1 --- Comment #8 from Buovjaga --- It is indeed a good idea to take backups. Apparently somehow your user profile got destroyed, which is not normal. Your global macros are stored in the profile: https://wiki.documentfoundation.org/UserProfile But about your issue with macro assignment, we would need examples that we can test with. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Lew changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #7 from Lew --- I provided as much information as I could when I originally reported this in May 2021. The problem was confirmed by tkin...@juno.com in Sep 2021. As far as details go, either the macros are there after the upgrade or they aren't. As far as "reproducible" goes, I can't replicate it except by waiting for the next update of LO. That's not workable, because I need to use the macros. So I fixed it by importing from a *.bas file and manually updating the macros per what changes I could remember. Right now I'm running OL 7.1.2.2(x64) at the link below, dated 18 months ago, on windows 10 pro on a dell laptop, config below. I don't know what else to say except that I rarely set things to update automatically, because when this happens it disrupts what I'm doing for hours, even days. Maybe put a note somewhere that if someone has a lot of macros and want to upgrade to a new version, they can export their macros to a *.bas file before upgrading manually. I see that you're up to 7.4 now. I don't know if the changes are worth it. I'll wait for v8 or a higher point release. I hope this helps. I donate annually. https://git.libreoffice.org/core/+/8a45595d069ef5570103caea1b71cc9d82b2aae4 Edition Windows 10 Pro Version 21H2 Installed onβ12/β31/β2020 OS build19044.2006 Experience Windows Feature Experience Pack 120.2212.4180.0 Device name ## Processor Intel(R) Core(TM) i7-10750H CPU @ 2.60GHz 2.59 GHz Installed RAM 16.0 GB (15.8 GB usable) Device ID ## Product ID ## System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #6 from QA Administrators --- Dear Lew, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Timur changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #5 from Timur --- 2 issues here: - we should have sample macro attached that worked before but it doesn't work in 7.1.2 - you should check that one with 7.2.2 (when available) because of fixed bug 144085. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #4 from tkin...@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.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Timur changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||4259 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #3 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 --- Comment #2 from Lew --- When I customize I've always noticed that the choice of program (writer/calc) is the app that I started in. If I'm in calc, the customizing is for calc. I've never knowingly chosen LO. The problem was only that I lost them all. Never happened before. I was able to load my backup *.bas file and restore everything. I can customize normally. To be complete: I don't do a lot of LO programming. Currently I have 39 macros, all stored in My Macros/Standard/Module1/*main*. Poor form, but I'm not a pro. Most are old, experiments, and not used, but the ones that I use are part of my normal workflow because they are real time savers. When I updated, my Module1/*main* was simply empty. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||79045_79...@mail.ru --- Comment #1 from Roman Kuznetsov <79045_79...@mail.ru> --- When you used a Customize dialog in Writer did you select "Writer" on Keyboard tab? The same question for Calc: When you used a Customize dialog in Calc did you select "Calc" on Keyboard tab? Are you sure you didn't change it to LibreOffice? and else one: your problem is in the loss of all your macro after LO updating or in impossibility to assign different macro to the same shortcut for different LO modules? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 Timur changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||9404 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 142063] Writer and Calc macro problems with update to LO 7.1.2.2
https://bugs.documentfoundation.org/show_bug.cgi?id=142063 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs