LibreOffice uses its own coding called LibreOffice Basic.Excel with VB codes and macros
Chapter 13 - Getting Started with Macros - Using the Macro Recorder … and Beyond
and there are some brief examples under the heading
Writing macros without the recorder
It's my use of VBA, Outlook, Access that would stop me considering any alternative to MSOffice.
Best of luck,
- Windows 11 Home x64 Version 22H2 Build 22621.2283