Visual Basic is not multi-platform and would require significant changes from one plateform to another (Visual Basic, Real Basic, AppleScript…). Many other Python libraries are not interface-oriented, creating directly the file in the Open Document format and saving it to disk with the correct extensionįor the choice of the language, I would first insist on the multi-platform requirement, which means it’s better if the macro / script can be executed on different platforms such as Windows, Mac OS or Linux, because LibreOffice is also multi-platform and documents will be shared between users from which we cannot expect a particular platform.

The API is interface-oriented, meaning your code communicate with the controller of the interface and the document has to be open. Among them are : Visual Basic, Java, C/C++, Javascript, Python. Many languages are accepted by the LibreOffice API, thanks to the Universal Network Objects (UNO). Macros are scripting for the office suite. Which language choice for writing your LibreOffice macros ? I would recommend you to set Macro security to Medium which will not block nor allow macros but alert you to choose if you trust the editor of the document :

I’ll speak about LibreOffice now, but the same is true for OpenOffice.Īnd in the menu bar LibreOffice > Preferences, enable macros LibreOffice was a fork of (when OpenOffice went under Oracle’s umbrella) and is built on the original code base.īoth are equivalent, but the usual advise is to use LibreOffice ( see the differences) since it is the project of the volunteers from the open-source community and has been developping more quickly. OpenOffice and LibreOffice are the main open-source office suites, the opensource equivalent to Microsoft Office, to create text document, spreadsheets, presentations and drawings. Interface-oriented programming in OpenOffice / LibreOffice : automate your office tasks with Python Macros

Libreoffice base python