LibreOffice Macros: Manipulation of Annotations.

What Will I Learn?

In this video you will learn:

• How to create annotations.
• How to create an event in a spreadsheet

To use the following properties and methods:

• spreadSheet.annotations
• annotation.position.row
• annotation.position.column
• annotation.getByIndex ()
• annotation.insertNew
• annotation.isVisible
• annotation.annotationShape.fillColor
• annotation.annotationShape.charFontName
• annotation.annotationShape.charHeight
• com.sun.star.sheet.CellFlags.ANNOTATION

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 show you how to use annotations using LibreOffice Basic. We explore the most used properties and methods, highlighting the difference between current versions of LibreOffice and previous versions.

This video also serves as an introduction to events. I show you how to use a spreadsheet event to make one of the procedures created during the video run automatically against any change in the spreadsheet content.

The code created during the video is available at 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.