[Libreoffice-bugs] [Bug 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 Xisco Faulí changed: What|Removed |Added Resolution|FIXED |WORKSFORME --- Comment #11 from Xisco Faulí --- (In reply to Alan from comment #10) > Installed 6.2.2.2 from Ubuntu's repro. The issue is gone, macros take the > right amount of time. Bug closed for me. > Thanks! Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified. -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 Alan changed: What|Removed |Added Resolution|--- |FIXED Status|NEEDINFO|RESOLVED --- Comment #10 from Alan --- Installed 6.2.2.2 from Ubuntu's repro. The issue is gone, macros take the right amount of time. Bug closed for me. Thanks! -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #9 from Xisco Faulí --- Hello Alan, LibreOffice 6.2.2.2 is going to be released today, could you please try again with this version to see if the problem has been resolved meanwhile? Thanks in advance -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #8 from raal --- Tested with Version: 6.3.0.0.alpha0+ Build ID: c7ad7849d54fd3dad67e7779102f65b8b2f04881 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; and macro is quick - 1 second. -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 Alan changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #7 from Alan --- Xisco Faulí, I played around with all the options that reset the user profile with the same results. I then deleted my entire profile folder so when I restarted libreoffice would create a default profile. Same results although it may be a second quicker, I didn't actually time it before. I tested it in 6.1.5 from a fresh download and the issue is not there. The macro completes quickly. I tested with a newly generated profile and my current profile. No perceivable difference so it appears to be some change from 6.1 to 6.2 is causing this. I see that you tested it in a gtk environment. Do you have access to a kde environment? I'm running Kubuntu 18.04.2 (KDE 5.44.0 / Plasma 5.12.7). Maybe it has to do with the switch from kde4 to kde5? Drew Jensen, The only third party tool I use is MRI but that is all commented out. Do you mean the 'Clear Everything' buttons? I wrote that code and keep it under the Standard dialog instead of the spreadsheet itself because that's where I keep all the code. I didn't include that code in this bug report since it isn't relevant in this case. If it isn't the clear buttons' code what sub is it in? -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 --- Comment #6 from Drew Jensen --- (In reply to Alan from comment #4) > Created attachment 149176 [details] > Code for spreadsheet Thanks - that did it. 1st - I agree you should check you user directory as a good first step. 2nd - there does seem to be a difference between 6.0 and the later versions but the difference appears small. Nothing close to the 10 seconds mentioned in the social media post. This morning though I ran the macros from the UI so don't have actual time values for any difference. What I'll do now is run this again but from a test harness script to get precise timings. (also will update the different versions to the latest builds before the test). 3rd - I noticed that there is a third party library in use when the macro to clear the copied sheets is used, which of course fails here as I don't have access to that third party tool. I wonder if maybe that is playing in somehow here (though unlikely perhaps). -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org --- Comment #5 from Xisco Faulí --- I can't reproduce it in Version: 6.3.0.0.alpha0+ Build ID: a8f21e120b1073d7019d41e85cc9a15104ed5c93 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 --- Comment #4 from Alan --- Created attachment 149176 --> https://bugs.documentfoundation.org/attachment.cgi?id=149176=edit Code for spreadsheet -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 --- Comment #3 from Alan --- I'm sorry about that. I missed 2 functions I wrote at the end. Should have tested that it worked first. I've uploaded the complete set of code I use for that spreadsheet. -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 --- Comment #1 from Alan --- Created attachment 149168 --> https://bugs.documentfoundation.org/attachment.cgi?id=149168=edit example spreadsheet -- 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 123371] Macros are extremely slow in 6.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123371 --- Comment #2 from Drew Jensen --- Trying to confirm the issue and I'm having a problem with the macro code: CellVal=GetCellContentsString(0,"G4") Throws and error of function not found? Is there another local library which you might of overlooked? -- 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