Goals
- Know the macros possibilities in Libre Office
- Be able to create, modify and maintain macros
Program
History and versions
LibreOffice: fork of OpenOffice
Different components of LibreOffice: description, presentation, possibilities
Summary of differences with VBA (Microsoft Office)
Documents, libraries, modules and macros
Creation of a simple macro and presentation of the language
The macro editor: creation, edition, debugging
Variables and data maintenance
Adaptation and repetition thanks to tests and loops
Organization by functions
Various additional elements of the syntax and introduction to the object
Practical workshop: some calculation macros in Calc
General manipulations of the document
Events available to Basic
Principles of the API, resources at our disposal
Calc (spreadsheet): access to sheets
Calc: cells (value, formatting, sorting)
Calc: advanced functions
Writer (word processor): access to text and formatting
Draw and Impress: additional possibilities
Practical workshop: macros of all shapes in the various tools of LibreOffice
Duration
3 days
Price
£ 2495
Audience
All
Prerequisites
Good knowledge of OpenOffice or LibreOffice
Reference
BUR108-F
Sessions
Contact us for more informations about session date