OpenOffice Python Macros: Where Can I Find Useful Documentation?

Question

I'm trying to make a macro for OpenOffice Calc that will switch the background color of cells containing a user-defined value. Since I do not know OpenOffice Basic and do not want to study it, I would like to write my macro in Python.

The problem is that I cannot find useful documentation on how to write Python macros. From the reading I made, it seems that I can’t set up a dynamic environment from which I can independently study the corresponding objects (objects), so I will have to rely solely on the documentation. Where can I learn how to write my macro?

EDIT:

I already know about Python as a macro language , but it only answers where to put Python files. It does not say anything about the API, how to search and modify cells, etc.

In addition, there is no XSCRIPTCONTEXT information that OOo appears to provide as a global variable. Since I cannot work interactively, I cannot interrogate this variable to find out about it.

EDIT 2:

I found several pages that contain bits and pieces of information, but they are either terribly incomplete or require comprehensive knowledge of the UNO API. So far I have not found anything useful. I just don't have time to try to learn the whole API so that I can understand one part of it, especially since I would need to learn C ++ so that I can understand the syntax used in the documentation.

Answer 1

I went through the same movements and wrote a blog post to share with others what I learned. It is a pity that now (almost six years later) the documentation and examples are still so scarce.

To learn api, check out two helper functions in dev.py

https://onesheep.org/scripting-libreoffice-python/

About your specific need to investigate XSCRIPTCONTEXT - it is not available when starting through a socket, but you can learn the interface here:

http://www.openoffice.org/api/docs/common/ref/com/sun/star/script/provider/XScriptContext.html