What Will I Learn?
In this video you will learn:
- How to create a style
- How to use that style to create conditional formats through macros.
- How to identify empty cells through queries.
- How to use the queries to identify and distinguish cells filled with any of the following types of data: VALUE, DATETIME, STRING, ANNOTATION, FORMULA.
- How to use queries about formulas.
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 we will use a style to create a conditional format. In the conditional formats we can use the same operators that we used in the previous video.
We will also start with the subject of queries. Queries are a quick tool to extract information from a spreadsheet. They also allow to identify empty cells, possible errors in data or in formulas or different types of data. In this video we will exemplify the use of the following types:
We will use the queryContentCells queries to also exemplify the use of the following types of flags:
For the case of the queryFormulaCells queries we will use these flags:
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.
- LibreOffice Macros: Manipulation of Ranges - Validations