APSO extensionīy default LibreOffice Python Macros are independent from any LibreOffice file. JRE is indeed required to be able to use macros within LibreOffice.

If your computer does not have Java Runtime Environment already you will need to install it through the Oracle website. Geany is perfect for ‘small jobs’ like we are going to do, but again it’s also fine to use a text editor like notepad.

They all have their pros and cons, here is t he Top 20 of the most popular ones. I am using a free open-source IDE called geany, but other popular ones are Eclipse, code::block and the famous Microsoft Visual Studio. If you are a programmer you may already have a preference for a simple editor or a clever one. The advantage of an IDE versus a simple text editor is that it offers tools to organise your codes, an IDE can also makes it easier to spot errors and offers all sort of features to speed up and ease coding like word auto-completion, search and replace. You will also need a text editor or even better an IDE (Integrated Development Environment) to write your python program.

Just web search for ‘python 3’ for your Operating system. For now I let you do it yourself, but I might write a quick help later. You also need the Python 3 programming language on your computer. (see at end of this article if you’re using a Linux ). LibreOffice is normally shipped with a PyUNO bridge to bind its components with Python language and to make it possible to program LibreOffice with Python. You will of course need LibreOffice, you can download the latest version here.

the APSO extension that’ll make things much easier.

In this Part 1 of LibreOffice Calc & Python programming tutorial we are looking at: Thanks for your patience, and thanks to Nukool for your comment, it really gave me motivation to write this course. I am finally starting to write this tutorial.

Python libreoffice calc