Calc/Add-In/Python How-To

This example will show you how to create a Python add-in for OpenOffice.org Calc 3.x. The add-in from the fictive DoobieCompany will

• Add custom spreadsheet functions to Calc.
• Make the custom functions available in Calc's Function Wizard.
• Be packaged as an .OXT file so an end-user can install the Add-in by simply double-clicking the .OXT package.

More detailed documentation is available in the full download here media:DoobieDoo-example.zip. It also includes some discussion about how to make user defined functions that work in both Calc and Excel.

The add-in was developed on Windows and the included make-script is Windows only. However, there is nothing particularly platform-specific code in the add-in so I guess you should be able to make it work on a *nix platform too.

You may also visit the original URL to see if there is a more up-to-date version available.