Differences between revisions 1 and 37 (spanning 36 versions)
Revision 1 as of 2012-01-03 22:46:56
Size: 2930
Editor: ?MarkusBrummer
Comment: First draft, structure copied from OpenOffice
Revision 37 as of 2021-12-01 09:55:06
Size: 8763
Comment: make translation header easy to include in pages
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
||<tablestyle="width: 100%;" style="border: 0px hidden">~-[[DebianWiki/EditorGuide#translation|Translation(s)]]: [[LibreOffice|English]] - -~||<style="text-align: right;border: 0px hidden"> ##For Translators - to have a constantly up to date translation header in you page, you can just add a line like the following (with the comment's character at the start of the line removed)
## <<Include(LibreOffice, ,from="^##TAG:TRANSLATION-HEADER-START",to="^##TAG:TRANSLATION-HEADER-END")>>
##TAG:TRANSLATION-HEADER-START
~-[[DebianWiki/EditorGuide#translation|Translation(s)]]: [[LibreOffice|English]] - [[fr/LibreOffice|Français]] - [[it/LibreOffice|Italiano]] - [[ru/LibreOffice|Русский]]-~
##TAG:TRANSLATION-HEADER-END
Line 4: Line 9:
~+!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 in Debian Wheezy and is available in squeeze-backports. It has good support for .doc, .xls, .odt, .ods and other popular formats. {{https://upload.wikimedia.org/wikipedia/commons/thumb/0/02/LibreOffice_Logo_Flat.svg/500px-LibreOffice_Logo_Flat.svg.png|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.

<<TableOfContents()>>
Line 8: Line 17:
LibreOffice is the default office suite in Debian Wheezy. You can also install it manually by using the following packages: == Using official Debian repositories ==
Line 10: Line 19:
 * [[DebianPkg:libreoffice]]
 * [[DebianPkg:libreoffice-gnome]] – for GNOME integration
 * [[DebianPkg:libreoffice-kde]] – for KDE integration
LibreOffice is the default office suite since Debian Wheezy. You can also add it manually by installing the following packages:
Line 14: Line 21:
LibreOffice has following components: {{{libreoffice-writer, libreoffice-calc, libreoffice-impress, libreoffice-math, libreoffice-draw, libreoffice-base}}}. ||<style="width: 25%; background-color: #000000; color: #FFFFFF; vertical-align: top; text-align: left;"> '''Packages''' ||<style="width: 75%; background-color: #000000; color: #FFFFFF; vertical-align: top; text-align: left;"> '''Notes''' ||
||<style="width: 25%; background-color: #f5f6f7; vertical-align: top; text-align: left;"> [[DebianPkg:libreoffice]] ||<#f5f6f7> 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''. ||
||<style="width: 25%; background-color: #FFFFFF; vertical-align: top; text-align: left;"> [[DebianPkg:libreoffice-gnome]] ||<style="width: 75%; background-color: #FFFFFF; vertical-align: top; text-align: left;"> Optional GNOME integration ||
||<style="width: 25%; background-color: #f5f6f7; vertical-align: top; text-align: left;"> [[DebianPkg:libreoffice-kde5]] ||<style="width: 75%; background-color: #f5f6f7; vertical-align: top; text-align: left;"> Optional KDE integration ||
Line 17: Line 27:
{{
aptitude update
aptitude install libreoffice
}}

{{{
# apt update
# apt install libreoffice
}}}

== Using Debian backports ==

Add the relevant [[Backports|backports]] for your Debian version in your [[SourcesList]] file: [[http://backports-master.debian.org/Instructions/]]

Install LibreOffice from the newly added backports repo after updating your package listing with {{{apt update}}}. This is accomplished by using the {{{-t}}} flag followed by the name of the repo you've added for your version.

For example, on a Debian 11/Bullseye system, you might run:
{{{
# apt install -t bullseye-backports libreoffice
}}}

If further updates are backported later, you may re-run the previous command to install them.

== Using the project's own deb packages ==

!LibreOffice has a compressed archive containing the !LibreOffice suite on their own server: [[https://download.documentfoundation.org/libreoffice/stable/]]

To install on 64-bit machines, run:

{{{
# wget https://download.documentfoundation.org/libreoffice/stable/7.2.2/deb/x86_64/LibreOffice_7.2.2_Linux_x86-64_deb.tar.gz
# tar -xvf LibreOffice_7.2.2_Linux_x86-64_deb.tar.gz
# cd LibreOffice_7.2.2.2_Linux_x86-64_deb/DEBS/
# dpkg -i *.deb
}}}
Line 23: Line 60:
Some components of LibreOffice require a Java Environment to achieve full functionality. LibreOffce metapackage recommends default-jre: this installs openjdk-6-jre. In ''Squeeze'' the user can choose to install also sun-java6-jre, in ''Wheezy'' the user can choose also openjdk-7-jre. To install java manually in LibreOffice, Some components of LibreOffice require a Java Environment to achieve full functionality. The LibreOffice metapackage recommends DebianPkg: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:
Line 25: Line 62:
 * Open Synaptic
 * Install DebianPkg:openjdk-6-jre
 * Open LibreOffice, {{{Tools > Options > LibreOffice > Java}}}
 * Open Synaptic (or use your preferred method for package installation)
 * Install DebianPkg:default-jre
 * Open LibreOffice. Navigate to {{{"Tools" menu > Options > LibreOffice > Advanced > Java Options}}}
Line 44: Line 81:
== Fixing poor look and feel in LibreOffice ==

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

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), {{{gtk3_kde5}}} (GTK3 with KDE file pickers), and {{{gtk3}}} (GTK3 with GNOME integration if available).

For example, if you're trying to use LibreOffice with the KF5 theming plugin, you might run:
{{{
SAL_USE_VCLPLUGIN=kf5 libreoffice
}}}

A generic Qt5 plugin is available in the DebianPkg:libreoffice-qt5 package, however it is experimental and not yet considered ready for production, as it can introduce issues that don't manifest with any other theming plugin. Because of this, you're recommended to either use KF5, or to run LibreOffice with the {{{SAL_VCL_QT5_USE_CAIRO=1}}} environment variable set which forces it to use the same Cairo rendering path as the KF5 plugin:
{{{
SAL_USE_VCLPLUGIN=qt5 SAL_VCL_QT5_USE_CAIRO=1 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 [[SubstitutingCalibriAndCambriaFonts|Substituting Calibri and Cambria Fonts]].

== Fixing Blank PDF Export ==

Symptoms:
 * The PDF has the expected amount of pages, but no text.
 * Examining the PDF (for example in Okular, File > Properties > Fonts) shows no embedded fonts.

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 [[https://docs.libreoffice.org/vcl/html/pdfwriter__impl_8cxx_source.html|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.
Line 50: Line 131:

= Remote Control =
Impress can be remotely controlled via an Android device with the app [[https://f-droid.org/repository/browse/?fdid=org.libreoffice.impressremote|Impress Remote]] available from [[http://www.f-droid.org|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.

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

Using official Debian repositories

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 

Using Debian backports

Add the relevant backports for your Debian version in your SourcesList file: http://backports-master.debian.org/Instructions/

Install LibreOffice from the newly added backports repo after updating your package listing with apt update. This is accomplished by using the -t flag followed by the name of the repo you've added for your version.

For example, on a Debian 11/Bullseye system, you might run:

# apt install -t bullseye-backports libreoffice

If further updates are backported later, you may re-run the previous command to install them.

Using the project's own deb packages

LibreOffice has a compressed archive containing the LibreOffice suite on their own server: https://download.documentfoundation.org/libreoffice/stable/

To install on 64-bit machines, run:

# wget https://download.documentfoundation.org/libreoffice/stable/7.2.2/deb/x86_64/LibreOffice_7.2.2_Linux_x86-64_deb.tar.gz
# tar -xvf LibreOffice_7.2.2_Linux_x86-64_deb.tar.gz
# cd LibreOffice_7.2.2.2_Linux_x86-64_deb/DEBS/
# dpkg -i *.deb

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:

  • Open Synaptic (or use your preferred method for package installation)
  • Install default-jre

  • Open LibreOffice. Navigate to "Tools" menu > Options > LibreOffice > Advanced > Java Options

  • Activate “Use a Java runtime environment”
  • Choose your desired JRE provider
  • Restart LibreOffice (including quickstarter)

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.

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), gtk3_kde5 (GTK3 with KDE file pickers), and gtk3 (GTK3 with GNOME integration if available).

For example, if you're trying to use LibreOffice with the KF5 theming plugin, you might run:

SAL_USE_VCLPLUGIN=kf5 libreoffice

A generic Qt5 plugin is available in the libreoffice-qt5 package, however it is experimental and not yet considered ready for production, as it can introduce issues that don't manifest with any other theming plugin. Because of this, you're recommended to either use KF5, or to run LibreOffice with the SAL_VCL_QT5_USE_CAIRO=1 environment variable set which forces it to use the same Cairo rendering path as the KF5 plugin:

SAL_USE_VCLPLUGIN=qt5 SAL_VCL_QT5_USE_CAIRO=1 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:

  • The PDF has the expected amount of pages, but no text.
  • Examining the PDF (for example in Okular, File > Properties > Fonts) shows no embedded fonts.

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

  • Writer: /usr/bin/libreoffice -writer

  • Calc: /usr/bin/libreoffice -calc

  • Draw: /usr/bin/libreoffice -draw

  • Impress: /usr/bin/libreoffice -impress

  • Math: /usr/bin/libreoffice -math

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