LibreOffice/Calc crashing

Debugging Help.

For starters
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded

i’m refactoring some existing code. it’s several thousands lines long, and spans several class modules. Part of my rework, was to set some global variables in a class that is executed from an ‘openDocument’ event. And likewise, a set of ‘set to nothing’ statements on ‘documentisbeingclosed’ event.

Once the workbook renders, im running ‘process’ macros manually, at this point, but the final intention is to assign them to a button.

So at the moment, im at the tail end of code / execute phase.
my problem is LibreOffice, keeps aborting. i get one run at the code, maybe two, before LibreOffice disappears, taking Calc and the Basic IDE with it. It restarts ok, well at least to the last backup, not necessarily the last export of code.

Thus, my topic, of help with debugging. Im assuming if a index was out of bounds, or a reference outside of a range, i would get a runtime error. But for the whole suite to disappear, it sounds more serious.

im not so worried about debugging my basic code, that i can do. Thinking more about debugging / tracing / logging libreoffice activity.

first question, are there any libreoffice logs that my offer some insight. is there something i can turn on, to capture the underlying cause.

as usual, thanks in advance.
-cw