I have a complex set of workbooks with functions defined in VBA that I would like to use in Calc.
Some of them contain quite large spreadsheets, and the macros and defined functions they use do not work under Calc’s version of Visual Basic. If I try to load a workbook with macros enabled, I might have to click Enter fifty or sixty thousand times to get through all the error messages. If I leave macros disabled, of course I cannot edit or debug them.
Is there any way to load the workbook directly into the debugger, so that I can trace the problems and rectify them? The online documentation says nothing about how to do this.
I just installed Linux Mint Cinnamon, which comes with version 126.96.36.199 of LibreOffice, if that’s useful to know.