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...3 min
Calc Macros
-
-
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)...3 min
-
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...4 min
-
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...1 min
-
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...2 min
-
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...3 min
-
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...2 min