Hi Dan
I know JavaScript and I just want to create a macro in Calc to fetch the
USD vs. EUR rate from a REST API, and copy that value from one cell to
another. I find it impossible to figure out where to start.
And I'm not alone - people who want to get started with writing macros have
a hard time as well:
https://stackoverflow.com/questions/21413664/how-to-run-python-macros-in-libreoffice
By comparison, it was far easier to get started with Excel's Visual Basic -
there was a clear reference, built into M$ Office
I don't follow your comparison, since Excel uses Visual Basic for
Application and LibreOffice has its own BASIC, IDE and API for almost
any kind of macro need, and documentation on LibreOffice Basic exist.
https://documentation.libreoffice.org/en/english-documentation/macro/
I can't verify ATM if Excel supports Python, Java and Javascript macros,
but LibreOffice does.
But the point on missing documentation for Javascript, Python and Java
is valid and deserves attention. We the community, is resource-short but
we left our wiki open for those who wants to write a tutorial about
these original forms of writing macros. Javascript and Python are both
languages of great popularity nowadays.
Cheers