libre office

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