After upgrading to macOS 26.0 Tahoe my LibreOffice Base macros will not run. So opening database with macros enabled results in a freeze. Database runs fine with macros disabled. Before upgrade all worked normally with macros enabled - database start form was opened upon startup and buttons controlled forms and reports. Macro security settings are set to medium as before upgrade.
I would disable the startup directly with a opening a form. Doing this for testing here with a SUB, which is named the same way:
SUB DesignViewOn … will be the procedure, which opens the form.
Rename it to SUB DesignViewOn1 … and create another Procedure without content:
SUB DesignViewOn
END SUB
So you could start without executing anything and have a look, if you could find the macro, which isn’t working well with your MAC.
Which kind of database do you use? Internal HSQLDB?
Thanks for your input!
Yes, using HSQLDB.
Per your suggestion I disabled opening my startup form on opening my database document. The database now opens with macros enabled and I am then able to open the startup form and all buttons (macros) work properly. So, there is something wrong with autostart on opening the database.
I’m was using this macro attached to Open Document Event of the database.:
SUB OpeningForm
Dim ObjTypeWhat
Dim ObjName As String
ObjName = “Start"
ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.FORM
If ThisDatabaseDocument.FormDocuments.hasbyname(ObjName) Then ‘Check the form exists’
ThisDataBaseDocument.CurrentController.Connect() ‘If the form exists connect to the database’
ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, ObjName, FALSE) ‘Open the form’
Else
MsgBox "Error! Wrong form name used. " & ObjName
End if
End Sub
It worked fine before upgrade to macOS 26 so I guess I need to figure out a new macro or autostart isn’t working in macOS 26?
You would only need one row:
SUB OpeningForm
ThisDatabaseDocument.FormDocuments.getByName("Start").open
END SUB
But: This can’t be the reason why it worked before and doesn’t work now.
.
What happens if you execute the macro OpeningForm through Tools → Macros → Run Macro?
You could also try to use the event View created of events of the database document when Tools → Macros → Run Macro works well.
Running the macro from the Tools menu works. But using the event View Created does nothing.
If you have set macro execution to medium you might be asked for executing macros every time you open the database file. I have set executing macros
Security Level → Very high
Trusted sources → Path for my database files
So I would never been asked for executing macros. This dialog disturbs the event View Created.
.
By the way: Open document seems to be the problem for your system. Write a bug for this and add a simple database file with a procedure connected to this event.
Thanks for your help RobertG
SIMPLE SOLUTION FOR LIBREOFFICE CRASHING AFTER UPDATING MAC OS TO TAHOE.
SOLVED TO ME.
FOLLOW BELLOW.
The issue with LibreOffice crashing and not opening documents on the Mac M1 with the latest Tahoe OS seems related to the user profile configuration rather than the app or OS installation itself. This aligns with your observation that LibreOffice works fine on a new user profile but crashes on your main profile.
Key points and solutions identified:
• LibreOffice user profile corruption is a known cause of crashing and inability to open files.
• The recommended solution is to reset the LibreOffice user profile by renaming or deleting the user profile folder. LibreOffice will then create a fresh user profile on the next launch.
• For macOS (including M1 models), the LibreOffice user profile folder is located at:
~/Library/Application Support/LibreOffice/4/user
• Rename this folder to something like user-old to preserve it as backup and then launch LibreOffice to generate a new profile.
• If LibreOffice works after this, the problem was profile corruption. You can then selectively restore configuration parts by copying subfolders from the old profile to the new one.
After the above steps it worked perfectly to me. Including that creating a new Libteoffice profile did not delete the last files opened list. Flawlessly !
You can also try to create a new user profile to test if LibreOffice will open files from there alternating user profiles. In my case it worked this way too and you can copy files to a Pendrive from main profile or copy files to Public Folder.
Let me know if this helped anyone!