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: [email protected]
Reporter: [email protected]
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.
