Base: LO crashes in form edit when I change Valuelist

English
#1

MacBook Neo with Apple 18 Pro chip OS Tahoe 26.4.1

LibreOffice version 26.2.3.2 (AARCH64)
Build 70e089b17412e4cb77734141…

Java - In the LibreOffice settings, under advanced it says
Eclipse Adoptium 25.0.3 - The Parameters and Class Path are both blank.

With the help of Google Gemini, I am attempting to teach myself Base. Thanks to the folks here in these forums, I have become fairly efficient at Calc and wanted to kick it up a notch. I am creating a double entry accounting database for my personal use, which is really here nor there.

We were at the stage where I was learning to create a data entry form. Gemini was showing me how to create a drop down list for the chart of accounts.

In edit mode,I managed to ungroup the particular box that I needed then right clicked, chose Control Properties, and selected the Data tab at the top. Where it says Valuelist, I was told to select .sql, but that crashed LibreOffice. I tried sql [native] and again it crashed.Gemini said there was a workaround using query, but that crashed. By crashed I mean “not responding” and Force Quit. Any help would be appreciated.

PS I turned my firewall off, as well as Clean my Mac. Problem persists.

#2

Try

  • Make sure LO is completely closed, even in the background and hidden processes.
  • Make a backup of your user file. (in windows its in the Roaming/Libreoffice/4 directory) Just rename the user directory to user_bak. All scripts and basic code are in here.
  • Start LO in safe mode and try using a listed configuration!
  • Use the reset user profile option under Reset to factory settings to recreate a clean user profile. Apply and restart. Verify basic operation.
  • Debug by moving components from the user_bak directory into the new user directory while LO is completely closed, restarting LO with each addition to check results.
#3

Ummm… Thank you for this. I am really green when it comes to this, but you did spell it all out for me. I will give it a go and let you know how it goes.

#4

There are many bugs in LO 26.2 when editing forms with Mac. See 170420 – LibreOffice Base hangs if I convert a text box to a list box in a form., which only shows one bug. There are linked some other bugs. Seems it is impossible to change any form control without producing a crash.
Only possibility: Take LO 25.8 and wait for a fix.

1 Like
#5

No need for this. Especially, if you use a local HSQLDB embedded.
.
General rule: Never compromise security, if a program crashes. If in doubt the crashing software has the problen, not your firewall.

#6

See Robert’s comment about the known bugs when trying to change the control properties of an existing drop-down form control. These bugs, particularly with form controls, have a tendency to occur on macOS more frequently than on other platforms, historically when a non-macos developer modifies code in the swriter forms module, without being aware of the potential consequences on thread and event management for macos.

It would be helpful to have a stack trace when LO hangs to see how it compares to that already posted in the bug report Robert references. These stack traces, if they are not displayed on screen when LO crashes, can often be found in the system logs, and sometimes also via the Console.app.

#7

If the stack report is the error log that gets sent to Apple, I just created one, but how do I attach it or share it with you?

#8

Ok. I see that I just have to paste it here. I am in the process of converting it to a pdf, but it is a 997 page document.

#9

Stackshots
Stackshots1590×1490 390 KB

I hope this helps.

#10

Is LO 25.8 for use with the Apple 18 Pro chip?

#11

I confess to having no idea on that. What’s the architectural difference between a M4 and A18?
If they are conceptionally different, then I doubt LO will run on the A18, as it won’t have been compiled for it.

Reading up a bit on A18 Pro, it probably should run, but whether performance is going to be an issue is a whole other ball game. LO is quite a memory gobbler.

#12

Thanks for this. I suspect that it isn’t. Apple is putting Apple chips in all of their new equipment and have software called Rosetta that translates programs and apps that are not specifically designed for this chip. Every time that a non-compatible app is launched a pop up comes up and tells you to get the updated software from the app store or supplier. I can still use the software, for now, however, when Apple launches it’s next major OS it will not include Rosetta. LO 26.2 is compatible, but obviously has issues. I will downgrade and hope that a fix for 26.2 comes soon… Thanks again (Everyone) for your help. I appreciate it.

#13

A fix has just gone in from the recently hired Base developer for the form control issue. It is in the master daily build.

#14

Thank you for that. How do I get to the Master Daily Build? Once there, how do I find it, download it, and install it? Is it like installing a new/updated version of LO?

#15

https://wiki.documentfoundation.org/QA/Testing_Daily_Builds

#16

With the caveat that, currently, for me at least, the latest master daily build regularly hangs on any attempt to modify or create a form, irrespective of the database.

#17

I am literally at a stand still until they come out with a fix. It is a good thing that I am only creating a database to teach myself how to do it. If this was a work related database I’d be freaking out right about now.

Even though I don’t have a resolution, I at least know what the problem is, and that a solution will come. I am very grateful for this forum and for all of you who take the time to help people like me.

#18

Or you could use 25.8 as Robert already suggested. I left several computers in my company to use old version 7.5, because it just works.

#19

You could always move back to an earlier version where the problem doesn’t exist.

#20

That won’t work because that particular version will not have been written with the Apple chip pro in mind. I do not know when Apple is going to launch the next version of it’s OS, but it will not include the Rosetta program that translates non-compatible apps and allows them to continue to function. So, my choices right now are either, A) no base or B) no LO at all.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.