用Python为libreoffice Calc编写表格函数.pdfVIP

How to call a python function from OO Calc DP 8 Dec 2010 someonesdad1@ I dont care for using Open Offices 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 isnt 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 Im going to present here is simple but practical. Heres what will happen. Well call a Basic macro with the contents of two cells: SI(a1; a2). This Basic macro will 1) call the python function ToSI() with these two parameters and 2) return the value the python script returns to the spreadsheet cell it was called from. Cell a1 is a number and cell a2 is a string. Our python function will examine the first non-space character of the string in a2 and, if it is a valid SI prefix letter, will return the number in a1 divided by the appropriate power of 10. If the first character is not a valid SI prefix, the number is returned unchanged. I use this functionality in some spreadsheets, as it makes it easy to support engineering notation. The python code The python code to do this is (save it in a file named myscript.py): def ToSI(value, unit): Expects value to be a number and unit to be a string of zero or more characters. The first non-space character of unit is gotten and, if it is a valid SI prefix, the corresponding power of 10 is gotten and value is divided by this p