someonesdad1@gmail.com
I don't care for using Open Office's Basic macro language. I would love to be able to call python
functions from within a cell formula, as python is a powerful and easy-to-use programming
language. Alas, the bad news is this isn't possible. The good news, however, is that with a little
work using the Basic macro language, you can call python functions to do the heavy lifting. Some
associated bad news is that there is no built-in debugger or IDE for python code, so you write your
python scripts in a text editor and figure out what went wrong from the error messages.
The example I'm going to present here is simple but practical. Here's what will happen. We'll call a
Basic macro with the contents of two cells:
SI(a1; a2)
. This Basic macro will 1) call the python
function
ToSI()
w