What Will I Learn?
In this video you will learn:
- How to create instance of com.sun.star.table.BorderLine
To use the following properties and methods:
- Color
- OuterLineWidth
- TopBorder
- LeftBorder
- RightBorder
- BottomBorder
- IsCellBackgroundTransparent
- HoriJustify
- VertJustify
- ParaIndent
- IsTextWrapped
- RotateAngle
- RotateReference
- Position.X
- Position.Y
- Size.Width
- Size.Height
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 continue to show you how to change the properties of the "LibreOffice Calc" cells. In this second part we focus mainly on the modification of cell formats or ranges through Basic. This includes the modification of the edges, the filling, the wrap, and the rotations.
Code used in the video: LINK
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.
Posted on Utopian.io - Rewarding Open Source Contributors