Description: I've a workbook with macros I've used for a long time and worked perfectly. Last time I used it was in January 2019, then with the lastest LibreOffice version. Now, strange things happen. Buttons on the sheet are flickering all the time and macros take endless time to run. The buttons are flickering even when macros are disabled. When editing macros, all colors disappear when text is selected. I haven't done any more research than just observing this A macro that took less than five seconds takes around two minutes now. Actual Results: See description Expected Results: See description Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows 10 Pro (Version 1909 Build 18363.476) OS is 64bit: yes!
I discovered that the screen is not updating after ScreenUpdating = True That's why I thought macros were run very slowly. I have to minimize and restore Calc to see updates! Even marking a range needs minimizing and restoring to see the selection. I guess it's not necessary to say this is more than frustrating
> Buttons on the sheet are flickering all the time and macros take endless time > to run. The buttons are flickering even when macros are disabled. i think this issue is a duplicate of: Bug 121963 - button flashing - mouse wheel zooming breaks should be fixed with LO 6.3.4 *** This bug has been marked as a duplicate of bug 121963 ***