Free online tutorials
Assign the macro to a LibreOffice Control Button. When you write a macro within libreOffice, you will quickly realise something. It’s not really convenient to execute macros through the Macro Manager. This is because you need to access that menu,…
Read more
I am finally starting to write this tutorial. Thanks for your patience, and thanks to Nukool for your comment, it really gave me motivation to write this course. In this Part 1 of LibreOffice Calc & Python programming tutorial we…
Read more
This article helps you decide whether to embed your python macro in the file. It also explores saving it in a macro repository. With the APSO add-on (see previous article) you can embed your macro within the LibreOffice File. This…
Read more
First let’s get the coding done, then we’ll dive in to it. You can either copy this block of code above or better type it yourself. Typing the code yourself will take longer but it’s the best way to remember…
Read more
In this episode of my LibreOffice Calc & Python Programming tutorial, we are going to write our first Python Macro. It will write ‘Hello World’ in cell A1 of a LibreOffice Calc document. How exciting is that!?! Here is the…
Read more
Using the code created in part 8, in this part 9 we are going to manipulate the data with functions getDataArray, setDataArray and Python Tuples. In this first example we are going to reverse the order of data within a…
Read more
This time we are going to create a new Range of Cells and fill it with the data stored in our tuple created in part 7. Here is the plan for this tutorial: Start with code from the previous chapter…
Read more
The topic for this episode of my LibreOffice Calc & Python Programming tutorial series is to get the data stored in a range of cells in LibreOffice. And we are going to do that using some very useful dedicated Pythons…
Read more
In this episode of my LibreOffice Calc & Python Programming tutorial series I am going to talk about the different types of data stored in a LibreOffice cell, and what type to use in the Python code to keep the…
Read more
This episode of my LibreOffice Calc & Python Programming tutorial is an annex to the normal series. In this article I am going to show you a quick way to execute your python scripts.The idea is simple: you assign a…
Read more