Information and resources for LibreOffice macros

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Macros
• General Macros
• Macros for Writer
• Macros for Calc
• Macros for Impress
• Macros for Draw
• Macros for Base
• Macros for Math
• Basic/Python

Documentation for macro writers and users

Andrew's Macros

A chronicle of information on the basic macro language with example scripts by Andrew Pitonyak.

• www.pitonyak.org (as ODT, as PDF)

LibreOffice Basic Guides

• Basic Programmer's reference
• OO.o Basic Programmer's guide (odt, pdf)
  • StarOffice 8 Programmierhandbuch für BASIC 8, 2005 in german (in English)
  • StarOffice 7 Office Suite - Basic Programmierhandbuch, 2003 in german (in English)
• LibreOffice Basic Guide
  • OO.o historic Basic Guide website
• LibreOffice Basic Macro Tutorials
• StarOffice (Basic) programmer's Tutorial, May 2000

LibreOffice API

LibreOffice scripts make use of the LibreOffice API , documentation is available at:

• api.libreoffice.org
• LibreOffice Developer's Guide
  • Historic OpenOffice.org 3.1 Developer's Guide
• ScriptForge Library
• LibreOffice Programming

Python as a macro language

It is possible to use python as a macro language, more details can be found at this page here:

• Python as a macro language

LibreOffice Python Guides

• Python Programmer's guide
• Designing & Developing Python applications

Tools - Collections

Tomaž's Development Tools

• Since LibreOffice 7.2, an object inspector tool is included, found under Tools -> Development Tools (see release notes).
• The tool is similar to the X-Ray and MRI extensions mentioned below.
• Read more in Tomaž's blog posts: part1 part2 part3

Extensions

• X-Ray (via the WayBackMachine) Basic macro is displaying API objects and is exploring their content. It also displays most Basic datatypes. Its integration of API documentation for services, interfaces, properties and methods is limited to OpenOffice.
• Alternative Python script organizer (apso) helps managing Python modules as LibreOffice or OpenOffice libraries.
• MRI It is not always clear at design time which services a UNO object actually supports. MRI (My Reflection and Introspection) displays the properties, methods, services, interfaces which are provided by an object variable (latest release).

Lanedo Labs (archived)

• Spreadsheet Population
• Mail Merge

Code Snippets

A set of code snippets in Basic covering many parts of LibreOffice:

• Primitives in Basic

The OpenOffice CodeSnippet website had a collection of macros in various scripting languages:

• http://codesnippets.services.openoffice.org
  • Note - the site is down, but the page is still available through the Wayback Machine⁠ at archive.org.