I am not a programmer but do a lot of Linux scripting. This comparison might help to answer your questions:
https://eklausmeier.wordpress.com/2013/10/27/programming-in-excel-vba-compared-to-libreoffice-openoffice-calc/
Thx much.