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
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
Let’s get started with LibreOffice Calc & Python programming: Software LibreOffice You will of course need LibreOffice, you can download the latest version here.LibreOffice is shipped with a PyUNO bridge. This bridge binds its components with the Python language. It…
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
Let’s start with the full code, then dive down First we need to import the uno library and the specific PropertyValue function Then let’s set the couple of service definitions that we need: We create 3 functions: create_instance: new_document_from_template: This…
Read more
Watch year 2025 edition of The World Famous ‘Runner Beans Race’.
Usually the first statement, when scripting with python to work on a LibreOffice document, would be:desktop = XSCRIPTCONTEXT.getDesktop() getDesktop() is a method of the object XSCRIPTCONTEXT and returns the Desktop Reference on which our script can interact with. This reference…
Read more
When you program a script within LibreOffice, accessing the XSCRIPTCONTEXT object is the starting point for controlling LibreOffice documents. SCRIPTCONTEXT is an object of class ‘pythonscript.ScriptContext’.This object provides connections with running instances of LibreOffice and has four useful methods:getDocument ()getInvocationContext…
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