https://bugs.documentfoundation.org/show_bug.cgi?id=162583

            Bug ID: 162583
           Summary: hash character in module1.XBA file previously
                    interpreted as comment but now crashes LibreOffice at
                    start
           Product: LibreOffice
           Version: 24.8.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: andrew.james.he...@gmail.com

Description:
I had some (simplified below) VBA code in
C:\Users\<user>\AppData\Roaming\LibreOffice\4\user\SafeMode\basic\Standard\Module1.xba

Sub testMsgBox()
        Dim sVar As Integer
        #sVar = MsgBox(&quot;test&quot;)
End Sub

In the version 24.2.2.2 this wasn't causing any issues. I assumed the line
beginning with the # character was being ignored/ commented out.

When I installed 24.8.0.3_Win_x86-64.msi today, opening any LibreOffice Writer
or Calc file would immediately crash with the VBA editor/ IDE displaying the
above line. It appears to be the hash character is no longer interpreted as a
comment, if it ever was. After a long period of trial & error, I finally found
that replacing the # with &apos; fixed the problem.

Steps to Reproduce:
1.Tools > Macros > Edit > add a subroutine
Sub testMsgBox()
        Dim sVar As Integer
        #sVar = MsgBox(&quot;test&quot;)
End Sub
2. close program & restart
3. observe crash

Actual Results:
crash with VBA stuck on line beginning with hash character

Expected Results:
the program should open without error


Reproducible: Always


User Profile Reset: No

Additional Info:
no other info - make this textbox optional?

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to