LibreOffice Macros: Manipulation of Ranges - Validations

What Will I Learn?

In this video you will learn:

• The use of different types of validation through .ValidationType.

• The use of different types of alerts through .ValidationAlertStyle.

• The application of the different types of conditional operators of .ConditionOperator.

• Manipulation of validation properties using .TableValidation service.

All derived from the com.sun.star.sheet object.

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

Either choose between the following options:

• Intermediate

Description

Previously, in a previous tutorial of this series I had shown how to apply validations using the UNO Service through the Dispatcher. Actually, that procedure only called the dialog box and the user had to fill in the parameters of the validation.

In the present tutorial we will explore the use of validations in a deeper way. We will assign each of the parameters directly in the range object. Within this learning session we will make use of the following services, properties and enumerations.

Source

Source

Source

Source

Model examples will be provided so that you can apply this knowledge to your needs.

The code generated for this tutorial can be consulted in the following link: CODE

Video Tutorial

Curriculum

Although the current video is in English, some of 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
• LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.
• LibreOffice Macros: Manipulation of spreadsheets
• LibreOffice Macros: Manipulation of cells.
• LibreOffice Macros: Manipulation of cells 2.
• LibreOffice Macros: Manipulation of Annotations.