LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.

What Will I Learn?

In this video you will learn:

• Associate a calc book with an object.
• Create a UNO service
• Scroll through the cells using Dispatcher functions
• Enter values ​​through Dispatcher functions
• Use the Dispatcher to give contiguous movements
• Fill cells with the Dispatcher
• Select ranges through the Dispatcher
• Send call features with the Dispatcher.

Requirements

The tutorial tries to be self-contained but it is necessary:

• Intermediate knowledge of LibreOffice Calc
• Basic knowledge of programming
• This video is part of a series therefore the knowledge of the previous videos of the series is used.

Difficulty

• Intermediate

Description

In this video I will introduce you to the use of LibreOffice Calc objects through Basic, for this we will use an example where we write a macro for the automatic creation of tables with validation ranges. Among other things you will learn to: associate a calc book with an object, create a UNO service, move through the cells using functions of the Dispatcher, enter values ​​through functions of the Dispatcher, use the Dispatcher to give contiguous movements, fill cells with the Dispatcher, select ranges through the Dispatcher and send to call functionalities with the Dispatcher.

Video Tutorial

Thumbnail of the video.

Curriculum

Although the current video is in English, the previous videos are in Spanish. You can find the other videos of the series in the following links:

• Introducción a las macros en LibreOffice
• LibreOffice Macros. Variables
• LibreOffice Macros. Variables Variant, constantes, variables de usuario y bloque With.
• LibreOffice Macros. Arreglos parte 1
• LibreOffice Macros. Arreglos 2: Redimensionamientos.
• LibreOffice Macros. Arreglos 3: Errores comunes

---

Posted on Utopian.io - Rewarding Open Source Contributors

---