https://bugs.freedesktop.org/show_bug.cgi?id=52603
Bug #: 52603
Summary: Excel Visual Basic code compatibility issue in
LibreOffice Calc: "Application.ScreenUpdating = False"
does not work!
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: All
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 64805
--> https://bugs.freedesktop.org/attachment.cgi?id=64805
Excel test file with macro
The Excel Visual Basic code "Application.ScreenUpdating = False" does not work
or will be ignored.
Because this code will be ignored it is not possible to disable the updating of
the screen and some macros are working very slow in LibreOffice!
Try to run the example macro in Excel and compare it with LibreOffice Calc.
Example macro:
Sub Test_ScreenUpdating()
' Testing Excel VBA Code in Libre Office:
Range("A4").Select
Application.ScreenUpdating = False
For i = 1 To 10000
ActiveCell.Offset(1, 0).Select
Next i
Range("A4").Select
Application.ScreenUpdating = True
End Sub
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
