Automating Libreoffice with macros
Office Automation
in addition to its comprehensive tool set, Libreoffice packs a built-in Basic-like scripting language that can be used to automate repetitive tasks and extend the suite’s default functionality.
In skilled hands, the LibreOffice Basic scripting language can do wonders, but you don’t have to be a programming expert to write simple or more advanced macros that perform useful tasks. Whether you are a Linux home user or an IT specialist, you can use the built-in scripting powers of the LibreOffice/ OpenOffice suite to automate recurring tasks. This article provides some examples you can use as building blocks for your own LibreOffice Basic coding projects.
Looking up Words
Traditionally, an introduction to a programming language starts with a simple example that displays the “Hello world!” message. It’s cute, but not particularly useful. So instead, I’ll start with something more practical, like a simple macro to look up the currently selected word in Wikipedia. The key element of the macro is the Shell command, which is used to call external programs.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
Direct Download
Read full article as PDF:
Price $2.95
News
-
Purism Launches a Mini PC
The makers of the Librem line of Linux-based laptops have released a mini PC.
-
openSUSE Leap 15.2 Adds AI Machine Learning
With the new release of openSUSE Leap comes some exciting new features, including machine learning.
-
Google’s Nearby Sharing Could Work with Linux
Google’s answer to Apple’s AirDrop feature is rumored to work with the Linux desktop.
-
System76 Launches Ryzen-Powered Laptop
The new System76 Serval WS includes a powerful AMD Ryzen CPU.
-
Linux Mint Drops Snap
Linux Mint has officially dropped their support for Canonical’s snap packages.
-
Lenovo Upping Their Linux Support
Lenovo is now offering full certification and Linux preinstalled hardware.
-
LPI Launches FOSSlife Website
Linux Professional Institute launches FOSSlife, a website for the FOSS community.
-
Tuxedo Computers Joins the Ryzen Bandwagon
Tuxedo Computers has released the Tuxedo Boot BA15 with an AMD Ryzen 3500 CPU.
-
Linux Apps on Windows Is Coming
Linux GUI apps will be coming to Windows Subsystem for Linux.
-
Linux Usage Is on the Rise
According to NetMarketShare, Linux saw a significant bump in usage during April.