The support for VBA in Calc is by no means complete. (There are a few VBA features I even iuse sometimes for a few lines of code in modules otherwise using the LibreOffice API.)
Python comes with a much larger toolbox of routines on the one hand. On the other hand it requires some overhead replaced by a few predefined variables and routines in Basic. The API you need to use with both languages is the same.
Anyway:
-1- You cannot export Calc documents with macros to Excel formats.
-2- Correct code running well in a demo may prove to not efficiently scale up (for sheets with many Ki rows e.g.). This is a point often regarded too late.
-3- Fortunately there isn’t something like a “Excel PC”, afaik.
-4- If you need to create spreadsheets for Excel, you need to use Excel - and to hope the versions won’t conflict.
-5- If you want to do it well and for an open community, use LibreOffice.
-7- Don’t trust too much in google - and be critical concerning contents!
