Libreoffice Examples

admin 11/23/2021
53 Comments

Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D. For example, conversion from one currency to another requires knowledge of the current conversion rate. If you input a formula in cell C1 of =0.75.B1 (for example to calculate the value in Euros of the USD dollar amount in cell B1), you will have to edit the formula when the exchange rate changes from 0.75 to. LibreOffice Impress Templates - A collection of 246 well-designed, modern, freely-licensed templates on GitHub. 3 Column basic Brochure This is a sweet & simple template for a 3 column Brochure and/or Pamphlet. Nothing Fancy, just evenly.

This article describes how to install LibreOffice 7.1 on Debian/Ubuntu-based Linux distributions, such as Linux Mint, MX Linux, Ubuntu and derivatives.

Tutorial

Draw lets you produce anything from a quick sketch to a complex plan, and gives you the means to communicate with graphics and diagrams. With a maximum page size of 300cm by 300cm, Draw is a an excellent package for producing technical drawings, brochures, posters and many other documents. LibreOffice Calc — developed for MS Windows, Linux, BSD and Apple Macintosh (Mac) operating systems by The Document Foundation. The Document Foundation was formed in mid-2010 by several large organisations such as Google, Red Hat, Canonical ( Ubuntu ) and Novell along with the OpenOffice.org community (developed by Sun ) and various.

LibreOffice 7.1 was released on February 3, 2020
LibreOffice 7.2 will be released in the Summer 2021. Find more information on LibreOffice 7.1 & 7.2 release dates on the official release plan.

Resources for LibreOffice 7.1 & 7.2:
Detailed 7.1 release plan
Detailed 7.2 release plan
LO 7.1 Release notes (new features list)
LO 7.2 Release notes (new features list)

Summary

A. Install LibreOffice 7.1 via ppa
 1. Add the LibreOffice PPA
 2. Install language packs
 3. Install additional packages
 4. Uninstall / Downgrade LibreOffice

B. Install LibreOffice manually
 1. Remove previous LibreOffice installations
 2. Install LibreOffice 7.1 manually
 3. Uninstall LibreOffice

A. Install or upgrade LibreOffice 7.1 via PPA (Ubuntu-based distributions)

Warning: updating LibreOffice via PPA or manually can cause multiple problems. It is recommended to stick with the default LibreOffice version which comes with your Linux distribution.

If you are an advanced Linux user and want to update/upgrade LibreOffice anyway, the “LibreOffice Packaging” team recommends installing or upgrading via ppa over using the *.deb files provided by Document Foundation.

Libreoffice

1. Add the LibreOffice PPA

The official LibreOffice PPA provides the latest “fresh” version. Run the following commands in Linux Mint or any Ubuntu-based distribution:

sudo add-apt-repository ppa:libreoffice/ppa
sudo apt update

sudo apt upgrade

Some guides recommend using apt full-upgrade instead of apt-upgrade.

The full-upgrade is absolutely fine (and won’t upgrade your Linux distribution!), but in this case does the same as apt upgrade. The apt manual page describes the full-upgrade variant as follows: “full-upgrade performs the function of upgrade but will remove currently installed packages if this is needed to upgrade the system as a whole”.

If you wanted to install (vs upgrade) LibreOffice, run the command below:
sudo apt install libreoffice

Alternative PPA for the 7.1 branch

This PPA has not be updated to 7.1 yet (as of April 2021).

The “LibreOffice Packaging” team also provides a 7.1.x specific PPA. This one will NOT upgrade automatically to the next major LibreOffice version (7.2).

If apt (or apt-get) keeps installing an old libreoffice version, try using this repository instead of the “Fresh” PPA.

sudo add-apt-repository ppa:libreoffice/libreoffice-7-1
sudo apt update

Now install OR upgrade LibreOffice:
sudo apt upgrade
or
sudo apt install libreoffice

2. Install language packs

Language packages in LibreOffice are spread over different packages. The user interface, templates and autotext features are contained in the libreoffice-l10n-* packages.

Spelling dictionaries, hyphenation patterns and thesauri are available in separate packages: hunspell-*, hyphen-*, mythes-* and libreoffice-help-*.

To find LibreOffice language packs for a specific language, replace the asterisk with a two-letters language code (mostly). For example, the corresponding German packages are:

  • User interface: libreoffice-l10n-de
  • Spelling dictionary: hunspell-de-de-frami
  • Hyphenation patterns: hyphen-de
  • Thesaurus (synonyms): mythes-de
  • Help: libreoffice-help-de

Libreoffice Base Templates

Install all of them with the following command:
sudo apt install libreoffice-l10n-de hunspell-de-de-frami hyphen-de mythes-de libreoffice-help-de

For US-English, there is no libreoffice-l10n-en-us package as it is the default language. Spelling, hyphenation, thesaurus (synonyms) and help files still have to be installed:
sudo apt install hunspell-en-us hyphen-en-us mythes-en-us libreoffice-help-en-us

For British or Canadian English, replace all us occurrences with gb or ca.

Find the right LibO language packs

How to find the letter code for your language packs? One option is to check the output of the following command:
apt search libreoffice-l10n-

Please note that spelling packages may have a different language code! In fact, there are more different spellcheck packages than user interface packages:
apt search hunspell-

Here are two examples for installing panguage packs in French and Spanish:

sudo apt install libreoffice-l10n-fr hunspell-fr-comprehensive hyphen-fr mythes-fr libreoffice-help-fr

sudo apt install libreoffice-l10n-es hunspell-es hyphen-es mythes-es libreoffice-help-es

3. Install additional packages

If the LibreOffice UI looks broken/old/ugly/awful, the GTK integration package may be missing. Install it and restart LibreOffice:
sudo apt install libreoffice-gtk3

Now LibreOffice should look more or less like in this screenshot (with the new default Colibre theme):

You may want to install additional icon themes. The new Colibre theme is installed by default. You could install all available icon themes with the following command (not recommended):
sudo apt install libreoffice-style*

The themes HiContrast, Industrial and Oxygen do not include SVG variants of the icons and are not actively maintained. Karasa Jaga was introduced as an alternative to Oxygen.
sudo apt install libreoffice-style-karasa-jaga

To change the active icon theme, go to:
Tools > Options > View > Icon style

The Sukapura theme by Rizal Muttaqin was introduced with LibreOffice 7.0 and is a default theme for LibreOffice installations on MacOS. Here is what it looks like and how to install it:

sudo apt install libreoffice-style-sukapura

Finally, here are a few more icon themes for LibreOffice worth installing: Breeze, Elementary and Sifr.
sudo apt install libreoffice-style-breeze
sudo apt install libreoffice-style-elementary
sudo apt install libreoffice-style-sifr

4. Uninstall / Downgrade LibreOffice

To go back to the default LibreOffice version provided by your Linux distro, you’ll have to remove AND purge the LibreOffice PPA.

The following command only removes the PPA. Your system will no longer receive updates from that PPA, but it doesn’t affect the packages installed from that PPA:
sudo add-apt-repository --remove ppa:libreoffice/ppa

Now purge the PPA to downgrade to the stock LibreOffice version:
sudo apt install ppa-purge
sudo ppa-purge ppa:libreoffice/ppa

If you used the dedicated LibreOffice 7.1 PPA, run these three commands insteads:
sudo add-apt-repository --remove ppa:libreoffice/libreoffice-7-1

sudo apt install ppa-purge
sudo ppa-purge ppa:libreoffice/libreoffice-7-1

B. Install LibreOffice manually

This installation method is based on the official .deb packages.

1. Remove bundled LibreOffice

LibreOffice 7.1 can be installed alongside older LibreOffice versions, but conflicts may occur.

To remove prior installations of LibreOffice:
sudo apt remove libreoffice-common

If you also want to remove LibreOffice configuration files, use the purge switch:
sudo apt purge libreoffice-common

Note that you could also use remove --purge, which is is equivalent to the purge command.

Remove unused dependencies:
sudo apt autoremove

2. Install LibreOffice manually

Step 1 of 3 – Download compressed packages

Download LibreOffice 7.1 from the official download page:
www.libreoffice.org/download/

Select Linux x86 (deb) for 32 bits systems or Linux x64 (deb) for 64 bits systems.

This how-to supposes that the downloaded file (and language packs) is saved in the “Downloads” directory situated in your home directory.

Download as many language packs as you need.

Step 2 of 3 – Extract the .deb packages

The downloaded files are compressed and have a .tar.gz filename extension. In case you want to learn more on these extensions, please follow these links: tar, gzip. To extract these juicy archives, open the “Downloads” directory. Look for a file named:

LibreOffice_7.1.2_Linux_x86_deb.tar.gz or
LibreOffice_7.1.2_Linux_x86-64_deb.tar.gz

Then, right-click on the file name and select “extract here “. Repeat the extraction process for all language packs. The .tar.gz archive(s) can now be deleted.

Step 3 of 3 – Install .deb packages

Open a terminal.
Change the current directory to the location of the .deb packages:
cd ~/Downloads/LibreOffice_7.1.x.x_Linux_x86_deb/DEBS

or for the 64 bits version:
cd ~/Downloads/LibreOffice_7.1.x.x_Linux_x86-64_deb/DEBS

(You don’t need to write everything: use Tab ↹ to autocomplete the command line, or copy and paste with the middle-click mouse button)

Finally, install all .deb packages:
sudo dpkg -i *.deb

In case you’re installing language packs, repeat the cd and dpkg steps for each language pack.

You’re done! No need to restart, LibreOffice is ready to be used.

If you have problems launching LibreOffice, try out the following command:
libreoffice7.1
or
/opt/libreoffice7.1/program/soffice

Libreoffice Math Examples

If you’re installing a development release (Beta) of LO 7.2, you can launch it with the following command:
lodev7.2

3. Uninstall LibreOffice

If you want to remove LibreOffice, use the following command:
sudo apt purge libreoffice7.1*

Alternatively, or for any other version, use:
sudo apt purge libreoffice?

Libreoffice Graphic Manager Memory Examples

If you want to remove a development (beta) version of LibreOffice, use the following command:
sudo apt remove lodev*

By Johannes Eva, January 2011 – April 2021

Read also:
How to install Firefox on any Linux distribution (Ubuntu, Linux Mint, …)
How to set default programs on Linux Mint or Ubuntu

Too many spelling or grammatical errors?

The author of this article is French and German, and obviously not a native English speaker. Any correction will be gladly accepted. Please send an email to

Related Posts:

  • How to Install Firefox 87 on Linux Mint, Ubuntu,… ... or any other Linux distribution. Photo: janeb13 / Pixabay, Pixabay License This how-to explains how to install…
  • Install Flash Player directly from Adobe on Linux… Adobe Flash Player freezes constantly on my Ubuntu installation, sometimes crashing Firefox. Most of the time…
  • Install VirtualBox on CentOS / RHEL / Scientific Linux This how-to is about installing VirtualBox on CentOS. Provided instructions should also work on Scientific Linux…
  • Install DVD support (libdvdcss) on Debian or Ubuntu On Linux, DVD support is provided through the libdvdcss or libdvdcss2 packages. Some distributions already include…
  • How to install a LEMP stack on Ubuntu Server 18.04 or 20.04 Introduction This guide shows how to get a full LEMP software stack installed on Ubuntu Server…
  • Multimedia, codecs, MP3 & DVD support on CentOS,… This tutorial details how to install full multimedia support, media codecs, MP3 & DVD support on…
  • How to change the default application for a type of… This howto explains how to change the default program to open all files with a given…

Home




This is a double-entry accounting system for registering Purchase Ledger transactions (invoices and bank payments). It may be suitable for small-businesses and / or for personal / family use. Features of the template include macro buttons for opening different forms and SQL queries for document / account balance calculations and list filtering.
Open PLA can run on the Raspberry Pi!
Screenshots:

Open PLA demo ‎‎(Youtube)‎‎


Screenshot (example of Open PLA report):



This is a database for recording information about donors / supporters, and donations received. It may be suitable for small charities. Open CDA was made on a R.Pi!
Screenshots: (Main form) (Letter created automatically by report)

Open CDA (Charitable Donor Accounts)‎‎





Download the XFDB database template.
This is a database template that can be used to store family contact details, and event details relating to contacts. It could also be used by a small business as an address-book. The database allows for showing relationships between different contacts.

YouTube Video - XFDB



To use the database templates, you will need to install LibreOffice.
LibreOffice is available for Linux, Windows and Mac.