but will the VisualBasic stuff work in OpenOffice/LivreOffice too?
Not sure what functionality OpenOffice /LiveOffice has, wouldn't be surprised if it didn't work.
You can just write formulas into the cells rather than creating functions. Just makes it bit more cumbersome.