LibreOffice 25.8.3 crashes if a BASIC syntax error window appears on both Windows 11 and Linux Ubuntu with versions downloaded from the official website.
.
For example: in a macro, I unintentionally inserted the same local variable declaration twice (Dim sMsg As String). The error window appeared, indicating a BASIC syntax error. Another time, without realizing it, I inserted two closing function braces when calling that function. Unexpected BASIC error.
.
In both cases, it was impossible to close the error window, either by clicking OK or the close button (X). The only way to close it was through the Task Manager on both Linux and Windows.
.
Furthermore, it was impossible to recover and reopen the database. The only solution was to start LibreOffice in safe mode to correct the error.
.
It worked fine under Windows, but Linux (Phew!)
.
What I find odd is that I’ve encountered this kind of error before with earlier versions, but there was a way to close the BASIC error window and simply continue in the macro editor.
.
In this case, the only way to recover the database intact is to boot into safe mode.
.
Has anyone else experienced this behavior?
Do you execute macro code while opening the Base file?
Which security mode you have chosen for executing macros? (Here: Very height, only files in a special path are allowed - so I could move the file anywhere else to edit the file with such an error while opening the file)
I have never had such an BASIC error before, which only could be solved by killing LibreOffice and restart…
Yes, I’m running macros when the database opens via two events: “Open document” and “View will be closed.”
.
Macro security is weak: all macros will run without confirmation.
.
When these errors occurred, I was in the macro editor. I was in a Basic module editing a macro and I was moving to another module to make changes to a macro with a specific link.
.
Currently, I’m trying to reproduce the problem, but the BASIC syntax error window closes when I click the OK button. This wasn’t the case in the two situations I described in the previous post.
You can try set the macro security higher. If the macro can not run, the document can open without error.
The problem I encountered, which occurred on both Windows and Linux, was not that I had to start LibreOffice in safe mode to fix the BASIC error in the affected modules. Luckily, safe mode exists.
.
The real problem was that the window that opened while working in the macro editor, displaying “BASIC syntax error,” completely froze LibreOffice. Clicking the OK button or the X in the upper right corner to try and close the window had no effect. On a second monitor, I had the BASE workspace displayed, and whether I clicked the X or tried to close LibreOffice, nothing happened.
.
The error window had completely frozen LibreOffice, and the only way I could get out of this situation was through the Task Manager.
.
Even worse, I tried restarting the .odb file, and the recovery window allowed me to retrieve the file, but once retrieved and launched, LibreOffice crashed, suggesting the file was corrupted.
.
By starting in safe mode, I was able to access the Basic modules and correct the errors that were visible behind the error window, even though LibreOffice was frozen.
.
I was then able to restart the file normally.
.
I’m trying to reproduce the problem, but I can’t completely remember all the steps I took to cause this crash.
.
That’s why I’m asking if anyone has encountered this problem before.