Why? I have written a lot of custom macros and created forms to assist filling data fields in large spreadsheets. I have written written macros that can open a CSV, comb through the contents and pick out the data I need to fill workbooks.
I’m not saying I’m especially tied to VB itself, I actually find it to be a pretty stupid language, but I do miss being able to write my on functions and effectly use Excel as a pre built GUI for whatever I’m trying to do. If there’s an alternative in Libre Office that I’m missing please point it out.
bookmeat@lemmynsfw.com 16 hours ago
LibreOffice supports python, JavaScript, and beanshell, as well as LibreOffice basic. The latter is similar to VBA and some VB scripts can even run unmodified.
help.libreoffice.org/latest/…/scripting.html
dellish@lemmy.world 5 hours ago
Oh cool. Thanks, I’ll check it out.