Writing a Macro in LibreOffice Calc – Getting Started
LibreOffice provides a way to write your own macro to automate various repetitive tasks in your office application. You can use Python or basic for...
Macro
Working with Dialog Controls in LibreOffice Calc using Macro – Part 1
This tutorial will cover on how to create a basic LibreOffice Dialog and adding various controls such as TextBox. Also it covers on how to...
String Processing in LibreOffice Calc Macro with Examples
In this tutorial, we will show how to do various common string processing using macro in LibreOffice. We will use LibreOffice Calc cells to use...
Form Processing with LibreOffice Calc Macro – Part 2
This is the second part of tutorial series of ‘Working with forms controls in LibreOffice/OpenOffice Calc’. First part can be found here. In the first...
Files and Directory Processing Using LibreOffice Calc Macro using Basic
This article demontrates how to process/read individual files and directories in Unix file system using Basic and LibreOffice Calc Macro and put the file names/directory...
Export or Save As PDF in LibreOffice Calc Sheets using Macro
This tutorial will show how to save a LibreOffice Calc sheet directly as a pdf file using basic macro. In many automation task this simple...
Use Open File Dialog using Macro in LibreOffice/OpenOffice
This tutorial will show how to open a file selection dialog in LibreOffice, OpenOffice using Macro. File selection dialog is used to select single/multiple file(s)...
Range Processing using Macro in LibreOffice Calc – Part 1
In many automation tasks we need to access spreadsheet using range to reduce processing time. One can access each cells using “row, column” way which...
LibreOffice Workbook Worksheet and Cell Processing using Macro
Spreadsheet applications like Calc consists of workbooks, worksheets and individual Cells. Many times it is required to process those using Macro to automate various tasks....
LibreOffice Calc Macro – Multiple values from vlookup result
This LibreOffice Macro Tutorial will search for data in cells like VLOOKUP function and the result will be stored in a different cells. This problem...
Using Form Controls in LibreOffice Macro
This tutorial will use the form controls such as a button inside LibreOffice Calc spreadsheet and assign a macro which will fire when the button...
Debugging LibreOffice Macro Basic using Breakpoint and Watch
This tutorial will teach you LibreOffice basic macro debugging technique using breakpoint and watch. This is built on the Ubuntu 14.04LTS and LibreOffice using basic....