Translation(s): English - Français - Italiano - Русский


LibreOffice Logo - by Christoph Noack (CC BY-SA)

LibreOffice is an open-source cross-platform office suite, serving as a near drop-in replacement for Microsoft Office. It was forked from OpenOffice 3.3.0 and has gained ground in Linux distributions as the default office suite. It has replaced OpenOffice since Debian Wheezy and is now the default office suite in all current versions of Debian. It has good support for .docx .xlsx, .odt, .ods, and other popular formats.

How to install LibreOffice

LibreOffice is the default office suite since Debian Wheezy. You can also add it manually by installing the following packages:

Packages

Notes

libreoffice

This libreoffice package is a metapackage. It automatically installs all packages and dependencies needed for a fully functional LibreOffice, including its major components such as libreoffice-writer, libreoffice-calc, libreoffice-impress, libreoffice-math, libreoffice-draw, libreoffice-base.

libreoffice-gnome

Optional GNOME integration

libreoffice-kde5

Optional KDE integration

To install the full LibreOffice suite, run

# apt update
# apt install libreoffice 

Getting the latest LibreOffice version

# apt install -t buster-backports libreoffice

Java Environment

Some components of LibreOffice require a Java Environment to achieve full functionality. The LibreOffice metapackage recommends default-jre which installs the recommended Java version for your version of Debian. This should require no further configuration, but if you want to manually install Java and configure LibreOffice for it:

Extending functionalities

Extend LibreOffice by installing these packages:

Fixing poor look and feel in LibreOffice

You should first make sure you have the appropriate theming package installed. On KDE Plasma 5, install libreoffice-kde5. On GNOME 3, install libreoffice-gnome. On other GTK-based desktops, install libreoffice-gtk3. On other Qt-based desktops, install libreoffice-qt5.

LibreOffice will try to auto-detect your desktop and use the most appropriate theming plugin based on this, but you can also force it by setting the SAL_USE_VCLPLUGIN environment variable. The available options are kf5 (Qt5 with KDE integration), qt5 (Regular Qt5), and gtk3 (GTK3 with GNOME integration if available).

For example, if you're trying to use LibreOffice with its KDE integration plugin, you might run:

SAL_USE_VCLPLUGIN=kf5 libreoffice


If you have bigger or smaller fonts in toolbar, you can fix it by enabling quick start option:

For GNOME:

echo 'OOO_FORCE_DESKTOP=gnome libreoffice --quickstart --nologo --nodefault' > ~/.config/autostart/lo.sh
chmod +x ~/.config/autostart/lo.sh

For KDE:

echo 'OOO_FORCE_DESKTOP=kde libreoffice --quickstart --nologo --nodefault' >  ~/.kde/Autostart/lo.sh
chmod +x ~/.kde/Autostart/lo.sh

Fixing Interoperability Problems

See Substituting Calibri and Cambria Fonts.

Fixing Blank PDF Export

Symptoms:

This can be caused by using the wrong VCL (LibreOffice desktop integration module) for the desktop environment, such as "qt5" instead of "kf5". Yes, surprisingly the PDF export depends on the VCL.

The current VCL is shown in the Help > About LibreOffice dialog box. Usually LibreOffice will pick the right VCL provided that the required package is installed, such as libreoffice-kde5. Otherwise, it can be forced with the SAL_USE_VCLPLUGIN environment variable.

Launchers

Remote Control

Impress can be remotely controlled via an Android device with the app Impress Remote available from F-Droid. It interacts with your slideshow presentation and allows slide previews, reading speaker notes, play/pause presentation and setting timers. Connection is done through Bluetooth or WLAN.

External links