
LibreOffice Macro Organization
This tutorial will share the basic idea of LibreOffice Macro file structures and organizations which can be used to export or share LibreOffice Macro as...
This tutorial will share the basic idea of LibreOffice Macro file structures and organizations which can be used to export or share LibreOffice Macro as...
This tutorial will show how to select a part of text and how to read the selected text from a TextBox control in LibreOffice using...
This tutorial will show how to default a string, insert a string at runtime, reading the string from a TextField control using Basic macro.
Exporting a LO sheet’s content to PDF is often necessary because of wide use of PDF files for distributions, reporting etc. In the earlier tutorial...
This tutorial will show how to get the human readable address of selected cells and ranges using basic macro.
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...
In this tutorial I will cover selection mechanism in LibreOffice Calc cells and via macro. getCurrentSelection() Method First we need to get hold of the...
Using macro you can clear everything that contains in a cell or in a range of cells. In this tutorial we will clear every type...
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)...
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...
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...
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...
In this tutorial I will show how to do basic date processing in basic via LibreOffice CALC cells. In basic, Date is a datatype used...
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...
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...
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...
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...
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....