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...
Calc Macros
-
-
Read Selected Text and Select Part of Text in TextField Control Using LibreOffice Basic Macro
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...
-
Insert and Read Text in TextField Control Using LibreOffice Basic Macro
This tutorial will show how to default a string, insert a string at runtime, reading the string from a TextField control using Basic macro.
-
Export or Save As PDF A Specific Range in LibreOffice Calc Sheets using 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...
-
Get the Selection Cell and Range Address using Macro in LibreOffice
This tutorial will show how to get the human readable address of selected cells and ranges using basic macro.
-
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...
-
Calc Cell Selection Processing Using Macro
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...
-
Deleting All Types of Contents from Calc Range using Macro
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...
-
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)...
-
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...
-
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...
-
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...
-
Date and Time Processing in LibreOffice Calc using Macro
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...
-
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...
-
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...
-
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...
-
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...
-
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....