[Libreoffice-bugs] [Bug 52603] New: Excel Visual Basic code compatibility issue in LibreOffice Calc: "Application.ScreenUpdating = False" does not work!

[bugzilla-daemon at freedesktop.org]

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: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: Tor24_1975314 at t-online.de


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.