https://bugs.documentfoundation.org/show_bug.cgi?id=149559
Bug ID: 149559 Summary: Excel Visual Basic compatibility issue in LibreOffice Calc: Application.ScreenUpdating = False does not allows work Product: LibreOffice Version: 7.3.4.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ovari...@zoho.com Description: This issue illustrates a problem shown in bug 149325. Hopefully ScreenUpdating is easier to fix as this is a smaller file illustrating the situation. ScreenUpdating can be set to true/false to enable/disable the screen updating when code is run. Disabling ScreenUpdating improves the speed of code execution. The code is: Application.ScreenUpdating = False ScreenUpdating can be enabled after the block of code with: Application.ScreenUpdating = True Steps to Reproduce: The attached Microsoft Excel spreadsheet has two subroutines, ScreenUpdateTestWorks() and ScreenUpdateTestFails() Actual Results: Correct behavior: Subroutine ScreenUpdateTestWorks() show a sheet with all the cells look empty (as the screen is not updating) when the MsgBox states: All the data is entered into the cells. The application will update the screen when you press OK to see the data. Correct behavior: Subroutine ScreenUpdateTestFails() show a sheet with all the cells incorrectly showing populated when the MsgBox states: All the data is entered into the cells. The application will update the screen when you press OK to see the data. The only difference between the ScreenUpdateTestWorks() and ScreenUpdateTestFails() is that ScreenUpdateTestWorks() has the line MsgBox "All cells in this sheet should be empty." Expected Results: Both subroutines should show a sheet with all the cells look empty (as the screen is not updating) when the MsgBox states: All the data is entered into the cells. The application will update the screen when you press OK to see the data. Reproducible: Always User Profile Reset: No Additional Info: Attaching the ScreenUpdating.xls file in the next comment as unsure how to attach now. Thank you -- You are receiving this mail because: You are the assignee for the bug.