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.
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.
dellish@lemmy.world 11 hours ago
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 10 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