title: OpenOffice Python macros: Where can I find useful documentation?
body: <p>I'm trying to make a macro for OpenOffice Calc that will toggle the background color of cells containing a user-specified value. Since I don't know OpenOffice Basic and have no desire to learn it, I'd like to write my macro in Python.</p>
  
  <p>The trouble is, I can't find any useful documentation on how to write Python macros. From the reading I've done, it appears that I can't set up a dynamic environment  from where I can examine the appropriate object(s) themselves, so I'll have to rely solely on documentation. Where can I learn how to write my macro?</p>
  
  <p>EDIT:</p>
  
  <p>I already know about "<a href="http://wiki.services.openoffice.org/wiki/Python_as_a_macro_language" rel="noreferrer">Python as a Macro Language</a>," but it only answers where to put Python files. It says nothing about the API, how to search for and modify cells, etc.</p>
  
  <p>In addition, there's no information about <code>XSCRIPTCONTEXT</code>, which OOo apparently provides as a global variable. Since I can't run interactively, I can't really interrogate that variable to learn about it.</p>
  
  <p>EDIT 2:</p>
  
  <p>I've found a number of pages that give bits and pieces of info, but they're either terribly incomplete or they assume a comprehensive pre-existing knowledge of the UNO API. So far, I haven't found anything useful. I simply don't have the time to try to learn the entire API just so I can understand one portion of it--especially since I'd have to learn C++ just so I could understand the syntax used in the documentation.</p>