BACKGROUND: Using Version 6, I created through "tools-macro-create a macro" about 15 macros. The total represent about 139 000 lines. The problem I report occurs in all the 7 versions. I tried all of them. PROBLEM DESCRIPTION: at the first time a macro is selected, it seems the software load all of them. That takes about 7 min. Then when there are loaded, using each macro is instantaneous. Based on that "constatation" (sorry for my english as I am french), I tried to delete all the macros, them copied again all of them in "module1" and the problem occurred again when I tried to execute a macro. BYPASS: when I start the system, I open a basic file, then I request to execute a macro and I wait macros are loaded. In the mean time I do anything else. Then I open my master file and I use macros as usual. If I stop the system I have to redo these actions. Hope my explanations are clear. Thanhs to take in consideration my request. Best regards. Jacques Bernede
Please attach here file with your macroses
Created attachment 183156 [details] file used with macros as requested
Your file doesn't contain any macro
Created attachment 183185 [details] file containing the macros used by my LIBREOFFICE (all files) Hello, I sent one file using macros as requested. These macros are not specific to 1 file but used by all my LIBREOFFICE files (path used: TOOL/MACRO/RUN A MACRO/MY MACROS/STANDARD/MODULE1/name/exec). I send to you these macros in tis TEXT file attached. Best regards. Jacques Bernede
Hello, I sent one file using macros as requested. These macros are not specific to 1 file but used by all my LIBREOFFICE files (path used: TOOL/MACRO/RUN A MACRO/MY MACROS/STANDARD/MODULE1/name/exec). I send to you these macros in tis TEXT file attached. Best regards. Jacques Bernede
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to QA Administrators from comment #6) > [Automated Action] NeedInfo-To-Unconfirmed I do not understand what you are expecting from me now
Hello, any feedback on this incident? Are you expecting something from me? In the mean time I continue to use V7. It seems there are some problems in the macros management process - when trying to create a new macro: 1) the delay is very, very long (in minutes) 2) SYSTEMATICALY I receive an error message "Erreur de syntaxe BASIC. Sous-procédure ou procédure fonction temp déjà définie". When I clic the OK button, libreoffice goes probably in a loop, because I never have the possibility to continue. I have to force libreoffice to stop. Hope that would helps to find the bug. Regards. Jacques Bernède
Hello, any feedback? Regards
I could not see any difference between Version: 7.5.0.2 (X86_64) / LibreOffice Community Build ID: c0dd1bc3f1a385d110b88e26ece634da94921f58 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL threaded and Version: 6.0.0.3 (x64) Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 12; OS: Windows 10.0; UI render: GL; Locale: ru-RU (ru_RU); Calc: CL Steps I did: 1. Copied everything from attachment 183185 [details] 2. Downloaded attachment 183156 [details]. 3. Opened it, confirmed "The document contains document macros" warning. 4. Opened Tools->Macros->Edit Macros. 5. In the Basic IDE, navigated to "V60.0.0 - DEAUVILLE- 22-08-28.ods"->Standard->Module 1, selected everything, removed, and pasted the code from attachment 183185 [details] copied at step 1. I noted that, despite comment 0 claimed there were about 139 000 lines, the actual result was more than 170 000 lines. 6. Saved and closed LibreOffice. ==> Now I had a file with macros. 7. Opened the file in 7.5.0.2 (took ~45 s), and using Tools->Macros->Run Macro, attempted to run a macro (I randomly chose INSERTLIGNETOUSBF). ==> It started executing instantly, but took long time to complete: ~140 s. 8. Run the same macro again ==> It shown the same behavior, starting instantly, and taking ~150 s. 9. Closed without saving. 10. Opened the file in 6.0.0.3 (took ~50 s), and using Tools->Macros->Run Macro, attempted to run the same macro INSERTLIGNETOUSBF. => It started executing instantly, but took even longer time: ~190 s. 11. Run the same macro again ==> Again, it started instantly, but took ~210 s. So I see no difference between 6.0 and 7.5 (or rather, 7.5 runs faster, and there's no slow first run, nor the next run goes fast). You didn't mention specific versions you used (you mentioned "version 6", which tells nothing which of the five major releases - 6.0 till 6.4 - or better, more than 30 minor releases - you meant); the file attached to comment 2 seems to be created using v.6.4.3.2 x64 for Windows, but you mentioned macOS in the bug's details; so please be very specific, which exact steps on which specific versions one needs to perform to see the problem. Also tell if you tried to reset profile, and also if you have network printers (could it be bug 42673, which was there long before 6.0?)
Would you mind trying LibreOffice 7.4.5. A scheduler issue got fixed on macOS since LibreOffice 7.4.4. So performance might be back to normal.
Dear Jacques Bernède, 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
Dear Jacques Bernède, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp