Calc

LibreOffice Calc & Python Programming: part 8 – From Python Tuple to Cells Range

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

LibreOffice Calc & Python Programming: part 7 – From Cells Range to Python Tuple.

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

LibreOffice Calc & Python Programming: part 6 – Type of a Cell content.

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

LibreOffice Calc & Python Programming: Annex 1 – Assign a Python Macro to a key.

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

LibreOffice Calc & Python Programming: Part 5 – display a message window.

In this episode of my LibreOffice Calc & Python Programming tutorial series I am going to show how to display a text message in a pop-up window. To do that you need to import the module msgbox that will allow…
Read more

LibreOffice Tutorial – Part 4 – function VLOOKUP

LibreOffice Tutorial – Part 3 – nested ‘IF’ and ‘AND’ function

This is the 3rd part of my LibreOffice Tutorial to learn about simple useful formula and a tiny bit of macro to make a simple daily agenda. In the first part we looked at renaming a sheet, entered some random…
Read more

LibreOffice Tutorial: Make a Time Schedule – Part 2 – the ‘IF’ formula

I moved my website to another web-host and during the process I did not realised that I transferred my word-press multi-site content to a word-press single site content. Along with a long summer looking after the children and back to…
Read more

LibreOffice Tutorial: Make a Time Schedule – Part 1 – Naming sheet, cell format and building logic for a simple agenda

Following my short series of article about time management (on my website superbusydaddy.com) , I wanted to share with you what tool I am using to make my life a bit easier: LibreOffice Free open source software. So I am…
Read more