LibreCalc

Python Macros in LibreOffice Calc The promised land of using python macros in LibreOffice Calc was my prime motivation to ditch other spreadsheets. Somehow that notion mired in UNO1 intricacies, further fuelled by scarcity of help available in LibreOffice community and world wide web. However since LibreOffice 7.2, things improved with scriptforge2 module for python. For Basic it was available since LibreOffice 7.1. Without further ado, let’s introduce the opening act!

Never go wrong while looking for reference value When you are looking for something in a single row or column and like to reference the value from the same position in different row or column, there are number of options available to you in LibreCalc. You may try LOOKUP, HLOOKUP, VLOOKUP and OFFSET depending upon the use case, as each of them has certain requirement to be adhered while using them.