Difference between revisions of "LibreOffice"

From ArchWiki
Jump to navigation Jump to search
(→‎Troubleshooting: Added a dirty workaround for people experiencing a bug with display not showing Impress slideshow on correct display on multidisplay setups)
(→‎LibreOffice toolbars unreadable with dark Breeze/Plasma 5 theme: LibreOffice 5.3 was released over 2 years ago)
 
(79 intermediate revisions by 35 users not shown)
Line 7: Line 7:
 
[[ja:LibreOffice]]
 
[[ja:LibreOffice]]
 
[[ru:LibreOffice]]
 
[[ru:LibreOffice]]
[[zh-CN:LibreOffice]]
+
[[zh-hans:LibreOffice]]
 
{{Related articles start}}
 
{{Related articles start}}
 
{{Related|Apache OpenOffice}}
 
{{Related|Apache OpenOffice}}
 
{{Related articles end}}
 
{{Related articles end}}
  
From [http://www.libreoffice.org/ Home - LibreOffice]:
+
From [https://www.libreoffice.org/ Home - LibreOffice]:
  
:''LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.
+
:LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.
  
 
== Installation ==
 
== Installation ==
  
[[Install]] one of the following packages from the [[official repositories]]:  
+
[[Install]] one of the following packages:  
  
* {{Pkg|libreoffice-fresh}} is the feature branch, with new program enhancements.
+
* {{Pkg|libreoffice-still}} is the stable maintenance branch, for conservative users.
* {{Pkg|libreoffice-still}} is the maintenance branch.
+
* {{Pkg|libreoffice-fresh}} is the feature branch, with new program enhancements for early adopters or power users.
  
 
{{Note|
 
{{Note|
 
* In the past, the installation of at least 1 language pack was required. Currently, LibreOffice detects your system defaults; manual installation of a language pack is no longer mandatory. See [https://help.libreoffice.org/Scalc/cui/ui/optlanguagespage/ignorelanguagechange#User_interface help.libreoffice.org] for additional information.
 
* In the past, the installation of at least 1 language pack was required. Currently, LibreOffice detects your system defaults; manual installation of a language pack is no longer mandatory. See [https://help.libreoffice.org/Scalc/cui/ui/optlanguagespage/ignorelanguagechange#User_interface help.libreoffice.org] for additional information.
* If you want the UK-English language pack, install {{Pkg|libreoffice-fresh-en-GB}}, not {{Pkg|libreoffice-fresh-uk}} (Ukrainian) or {{Pkg|libreoffice-fresh-br}} (Breton)!
+
* If you want the UK-English language pack, install {{Pkg|libreoffice-fresh-en-gb}}, not {{Pkg|libreoffice-fresh-uk}} (Ukrainian) or {{Pkg|libreoffice-fresh-br}} (Breton)!
 
* For SDK install {{Pkg|libreoffice-fresh-sdk}}.
 
* For SDK install {{Pkg|libreoffice-fresh-sdk}}.
* For Qt and GTK+ visual integration, see [[#Theme]].
+
* For Qt and GTK visual integration, see [[#Theme]].
 
}}
 
}}
  
Check the optional dependencies pacman displays. If you want to use LibreOffice Base, you must install a Java Runtime Environment: see [[Java]]. You may need {{AUR|hsqldb2-java}} to use [https://wiki.documentfoundation.org/Base#Java_and_HSQLDB some modules] in LibreOffice Base.
+
Check the optional dependencies pacman displays. If you use HSQLDB Embedded in LibreOffice Base, you must install a [[Java|Java Runtime Environment]]. You may need {{AUR|hsqldb2-java}} to use [https://wiki.documentfoundation.org/Base#Java_and_HSQLDB some modules] in LibreOffice Base.
  
 
== Theme ==
 
== Theme ==
{{Out of date|With version 5.0, GTK3 is the default, it isn't completely working however.}}
 
LibreOffice includes support for [[GTK+]] and [[Qt]] theme integration. See also [[Uniform look for Qt and GTK applications]].
 
  
As of LibreOffice v3.5.x toolkit libraries are checked in the following order:
+
LibreOffice includes support for [[GTK]] and [[Qt]] theme integration. See also [[Uniform look for Qt and GTK applications]].
  
gtk3 > gtk > kde4 > generic
+
LibreOffice will try to autodetect the most suitable VCL UI interface based on your desktop environment. To force the use of a certain VCL UI interface, use one of the {{ic|1=SAL_USE_VCLPLUGIN=gen}}, {{ic|1=SAL_USE_VCLPLUGIN=kde5}}, or {{ic|1=SAL_USE_VCLPLUGIN=gtk3}} [[environment variables]]. These variables can be uncommented in {{ic|1=/etc/profile.d/libreoffice-fresh.sh}} or {{ic|1=/etc/profile.d/libreoffice-still.sh}}.
  
To force the use of a certain VCL UI interface, use one of the {{ic|1=SAL_USE_VCLPLUGIN=gen}}, {{ic|1=SAL_USE_VCLPLUGIN=kde4}}, {{ic|1=SAL_USE_VCLPLUGIN=gtk}} or {{ic|1=SAL_USE_VCLPLUGIN=gtk3}} [[environment variables]]. These variables can be uncommented in {{ic|1=/etc/profile.d/libreoffice-fresh.sh}} or {{ic|1=/etc/profile.d/libreoffice-still.sh}}.
+
{{Note|
 
+
*When using the [[LXDE]] desktop environment, setting {{ic|SAL_USE_VCLPLUGIN}} in {{ic|1=/etc/profile.d/libreoffice-fresh.sh}} has no effect since the {{ic|1=SAL_USE_VCLPLUGIN}} [[environment variable]] is afterwards set to {{ic|1=gtk}} by the script {{ic|1=/usr/bin/startlxde}}. In order to use {{ic|1=gtk3}} toolkit with [[LXDE]] the {{ic|1=SAL_USE_VCLPLUGIN}} [[environment variable]] needs to be set after launching the desktop environment. [https://sourceforge.net/p/lxde/bugs/868/ upstream bug]
However, if it looks like it is using Windows 95/98 icons, go to ''Tools > Options...'' in the menus (which presents the Options Dialog), then select ''LibreOffice > Accessibility'' and uncheck "Automatically detect high-contrast mode of operating system".
+
*In LibreOffice 6.4, the {{ic|kde5}} backend will be [https://gerrit.libreoffice.org/plugins/gitiles/core/+/2113f3e7ee0ca5c07f224a54b627777b3a7b5fb0%5E%21/ renamed] to {{ic|kf5}}.}}
 
 
If that does not work immediately, you may need to change the icon set that is in use; this is also in the Options Dialog, under ''LibreOffice > View'' with two pop-up boxes for "Icon size and style" (the latter pop-up box should be changed to something other than "High-contrast").
 
 
 
=== Firefox themes ===
 
 
 
LibreOffice 4.x series is able to use Firefox themes. Enter LibreOffice options and choose ''Personalization > Select Theme'', then paste the URL of your favourite one. A convenient button in the dialog box lets you open the browser.
 
 
 
Themes can be found on [https://addons.mozilla.org/en-US/firefox/themes/ Mozilla's theme repository].
 
  
 
=== Disable startup logo ===
 
=== Disable startup logo ===
Line 60: Line 50:
 
== Extension management ==
 
== Extension management ==
  
The following additional extensions are available in the [[official repositories]]:
+
The following additional extensions are available:
  
*{{Pkg|libreoffice-extension-texmaths}}
+
* {{Pkg|libreoffice-extension-texmaths}}
*{{Pkg|libreoffice-extension-writer2latex}}
+
* {{Pkg|libreoffice-extension-writer2latex}}
  
For more extensions, check the [[AUR]], the built-in LibreOffice Extension manager, or [http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List libreplanet].
+
For more extensions, check the [[AUR]], the built-in LibreOffice Extension manager, or [https://libreplanet.org/wiki/Group:OpenOfficeExtensions/List libreplanet].
  
 
== Language aids ==
 
== Language aids ==
Line 71: Line 61:
 
=== Spell checking ===
 
=== Spell checking ===
  
For spell checking, please make sure {{Pkg|hunspell}} is properly installed; this should be the case for both still and fresh LibreOffice versions. Then install a language dictionary for hunspell like {{Pkg|hunspell-en}} for English, {{Pkg|hunspell-de}} for German, etc. Then enable the Writing aids by selecting the check-box in ''Tools -> Options -> Language Settings -> Writing Aids -> Hunspell SpellChecker''.
+
For spell checking, please make sure {{Pkg|hunspell}} is properly installed; this should be the case for both ''still'' and ''fresh'' LibreOffice versions. Then install a language dictionary for hunspell like {{Pkg|hunspell-en_US}} for American English or {{Pkg|hunspell-de}} for German. Then enable the Writing aids by selecting the check-box in ''Tools > Options > Language Settings > Writing Aids > Hunspell SpellChecker'' after restarting LibreOffice.
  
 
;Finnish
 
;Finnish
Unlike other languages, Finnish dictionaries use different naming. These four packages should be installed (in this order): {{Pkg|libvoikko}}, {{AUR|malaga}}, {{AUR|voikko-fi-malaga}}, {{AUR|hfstospell}} and {{AUR|voikko-libreoffice}}.
+
Unlike other languages, Finnish dictionaries use different naming. These four packages should be installed (in this order): {{Pkg|libvoikko}}, {{AUR|malaga}}, {{AUR|voikko-fi}}, {{AUR|hfstospell}} and {{AUR|voikko-libreoffice}}.
 +
 
 +
;Greek
 +
Project [https://sourceforge.net/projects/orthos-spell/?source=directory Orthos] provides more complete Greek spell checkers as Libreoffice extensions. Package {{AUR|libreoffice-extension-orthos-greek-dictionary}} provides a Greek-only spelling dictionary, while {{AUR|libreoffice-extension-orthos-greek-english-dictionary}} provides one that bundles Greek and US English.
  
 
=== Hyphenation rules ===
 
=== Hyphenation rules ===
Line 83: Line 76:
  
 
For the thesaurus option, you will need {{Pkg|libmythes}} and a mythes language thesaurus (like {{Pkg|mythes-en}} for English, {{Pkg|mythes-de}} for German, etc).
 
For the thesaurus option, you will need {{Pkg|libmythes}} and a mythes language thesaurus (like {{Pkg|mythes-en}} for English, {{Pkg|mythes-de}} for German, etc).
 +
 +
;Greek
 +
For Greek, instead of {{AUR|mythes-el}} you may want to try out {{AUR|libreoffice-extension-orthos-greek-thesaurus}}, which includes more words.
  
 
=== Grammar checking ===
 
=== Grammar checking ===
  
{{Accuracy|Unintelligible flow of ideas: "...the later is not packaged..." -- which one is "the later"? I can only say that LanguageTool ''is'' packaged as a [http://extensions.libreoffice.org/extension-center/languagetool LibreOffice extension].}}
+
For grammar checking, several tools are available. The most common is [https://www.languagetool.org/ LanguageTool]. You can either:
 
+
* install the {{AUR|libreoffice-extension-languagetool}} package, or
For grammar checking, several tools are available. The most common is [https://www.languagetool.org/ LanguageTool]. While the {{Pkg|languagetool}} is available in the [[official repositories]], the later is not packaged as a LibreOffice extension. It is thus recommended to install it with via the [[AUR]] package {{AUR|libreoffice-extension-languagetool}} instead. Even if this AUR package comes bundled with LanguageTool, this does not conflict with the one in the official repositories. In the future, it could even be possible to make that AUR package depend on the official {{Pkg|languagetool}} package.
+
* download it from the [https://extensions.libreoffice.org/extensions/languagetool LibreOffice Extensions page] and manually install it in LibreOffice through ''Tools'' --> ''Extension''
  
After this package has been installed, please make sure you have a [[Java]] runtime installed. Indeed, Languagetool uses Java and may slow down or briefly hang LibreOffice, particularly while opening documents. Fortunately this is usually only when initially opening a document and is usually not apparent otherwise.
+
After this extension has been installed, please make sure you have a [[Java]] 8 runtime installed ({{Pkg|jre8-openjdk}}). Indeed, Languagetool uses Java and may slow down or briefly hang LibreOffice, particularly while opening documents. Fortunately this is usually only when initially opening a document and is usually not apparent otherwise. Once installed, you want to enable it as the default environment for LibreOffice. To do that go to "Tools" --> "Options" --> "Advanced" and select the appropiate JRE (it will be shown as 1.8.0) then press "Ok". You will be prompted to restart the LibreOffice suite. Once restarted you will be able to install Languagetools without trouble.
  
Other grammar tools can also be found on the [http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List LibrePlanet extension page], on the [http://extensions.libreoffice.org/ official LibreOffice Extensions website] or [http://lingucomponent.openoffice.org/grammar.html OpenOffice's Website]. Please note all OpenOffice extensions are guaranteed to work with LibreOffice.
+
Other grammar tools can also be found on the [https://libreplanet.org/wiki/Group:OpenOfficeExtensions/List LibrePlanet extension page], on the [https://extensions.libreoffice.org/ official LibreOffice Extensions website] or [https://www.openoffice.org/lingucomponent/grammar.html OpenOffice's Website]. Please note all OpenOffice extensions are guaranteed to work with LibreOffice.
  
 
;French
 
;French
French-speaking users are advantaged here: they do not need to install LanguageTool nor Java. Dicollecte provides a nice Python extension, specifically designed for Frenchs. You can install it [http://www.dicollecte.org/grammalecte/telecharger.php from the website] or via this [[AUR]] package: {{aur|libreoffice-extension-grammalecte-fr}}. In any case, this extensions also comes with the French dictionaries otherwise provided by {{Pkg|hunspell-fr}}.
+
French-speaking users are advantaged here: they do not need to install LanguageTool nor Java. Dicollecte provides a nice Python extension, specifically designed for Frenchs. You can install it [https://www.dicollecte.org/grammalecte/telecharger.php from the website] or via {{AUR|libreoffice-extension-grammalecte-fr}}. In any case, this extensions also comes with the French dictionaries otherwise provided by {{Pkg|hunspell-fr}}.
  
=== Offline help for en-US ===
+
=== Offline help ===
  
As of version 5.2.2, {{Pkg|libreoffice-fresh}} provides the offline help files for en-US. Help files for different locales is provided by the appropriate libreoffice language package, (i.e., {{Pkg|libreoffice-fresh-en-ZA}} provides the help files for en-ZA locales).
+
{{Pkg|libreoffice-still}} and {{Pkg|libreoffice-fresh}} provide the offline help files for en-US. Help files for different locales is provided by the appropriate libreoffice language package, (i.e., {{Pkg|libreoffice-fresh-en-za}} provides the help files for en-ZA locales).
  
 
== Installing macros ==
 
== Installing macros ==
  
If you intend to use macros, you must have a Java Runtime Environment enabled. A Java Runtime Environment is enabled by default, but disabling it [[#Speed up LibreOffice|speeds up the program]].
+
If you intend to use macros, you must have a Java Runtime Environment enabled.
  
The default path for macros in Arch Linux is different from most Linux distributions. Its location is:
+
The default path for macros in Arch Linux is different from most Linux distributions. Its location is: {{ic|~/.config/libreoffice/4/user/Scripts/}}.
~/.config/libreoffice/4/user/Scripts/
 
  
== Speed up LibreOffice ==
+
== Troubleshooting ==
  
Some settings may improve LibreOffice's loading time and responsiveness. However, some also increase RAM usage, so use them carefully. They can all be accessed under ''Tools > Options''.
+
A general way to track down problems is the safe mode in LibreOffice:
* Under ''Memory'':
 
** Reduce the number of Undo steps to a figure lower than 100, to something like 20 or 30 steps
 
** Under ''Graphics cache'', set Use for LibreOffice to 128 MB (up from the original 20 MB)
 
** Set ''Memory per object'' to 20 MB (up from the default 5 MB).
 
** If LibreOffice is used often, check ''Enable systray Quickstarter''
 
* Under ''Advanced'', uncheck ''Use a Java runtime environment''
 
{{Note|For a list of functionality written in Java only, see: https://wiki.documentfoundation.org/Development/Java.}}
 
  
== Troubleshooting ==
+
$ libreoffice --safe-mode
  
 
=== Font substitution ===
 
=== Font substitution ===
Line 129: Line 117:
  
 
{{Merge|Font configuration}}
 
{{Merge|Font configuration}}
 +
 
Execute:
 
Execute:
 +
 
  $ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
 
  $ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
  
To make the change persistent, add {{ic|Xft.lcdfilter: lcddefault}} to your {{ic|~/.Xresources}} file, and make sure to run {{ic|$ xrdb -merge ~/.Xresources}} ([https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/271283/comments/19 source]. See [[X resources]] for more details.
+
To make the change persistent, add {{ic|Xft.lcdfilter: lcddefault}} to your {{ic|~/.Xresources}} file, and make sure to run {{ic|$ xrdb -merge ~/.Xresources}} ([https://bugs.launchpad.net/ubuntu/+source/cairo/+bug/271283/comments/23 source]). See [[X resources]] for more details.
  
 
If this does not work, you can also try adding {{ic|Xft.lcdfilter: lcddefault}} to your {{ic|~/.Xdefaults}}. If you do not have this file, you will have to create it.
 
If this does not work, you can also try adding {{ic|Xft.lcdfilter: lcddefault}} to your {{ic|~/.Xdefaults}}. If you do not have this file, you will have to create it.
Line 139: Line 129:
  
 
If LibreOffice hangs when trying to open or save a document located on a NFSv3 share, try prepending the following lines with a {{ic|#}} in {{ic|/usr/lib/libreoffice/program/soffice}}:
 
If LibreOffice hangs when trying to open or save a document located on a NFSv3 share, try prepending the following lines with a {{ic|#}} in {{ic|/usr/lib/libreoffice/program/soffice}}:
 +
 
  # file locking now enabled by default
 
  # file locking now enabled by default
 
  SAL_ENABLE_FILE_LOCKING=1
 
  SAL_ENABLE_FILE_LOCKING=1
 
  export SAL_ENABLE_FILE_LOCKING
 
  export SAL_ENABLE_FILE_LOCKING
  
To avoid overwriting on update you can copy {{ic|/usr/lib/libreoffice/program/soffice}} in {{ic|/usr/local/bin}}. Original post [http://www.crazysquirrel.com/computing/debian/bugs/openoffice-over-nfs.jspx here].
+
To avoid overwriting on update you can copy {{ic|/usr/lib/libreoffice/program/soffice}} in {{ic|/usr/local/bin}}. Original post [http://195.110.9.173/computing/debian/bugs/openoffice-over-nfs.jspx here].
  
 
=== LibreOffice does not detect my certificates ===
 
=== LibreOffice does not detect my certificates ===
Line 150: Line 141:
 
  export MOZILLA_CERTIFICATE_FOLDER=$HOME/.mozilla/firefox/XXXXXX.default/
 
  export MOZILLA_CERTIFICATE_FOLDER=$HOME/.mozilla/firefox/XXXXXX.default/
  
[http://wiki.openoffice.org/wiki/Certificate_Detection Certificate detection].
+
[https://wiki.openoffice.org/wiki/Certificate_Detection Certificate detection].
  
 
=== Run .pps files in edit mode (without slideshow) ===
 
=== Run .pps files in edit mode (without slideshow) ===
Line 161: Line 152:
 
#!/bin/bash
 
#!/bin/bash
  
f=$(mktemp)
+
f=$(mktemp --suffix .ppt)
cp "$1" "${f}.ppt" && libreoffice "${f}.ppt" && rm -f "${f}.ppt"
+
cp "$1" "${f}" && libreoffice "${f}" && rm -f "${f}"
 
</nowiki>}}
 
</nowiki>}}
  
=== Application Error (not starting) ===
+
=== Media support ===
 +
 
 +
If embedded videos are just gray boxes, make sure to have installed the [[GStreamer#Installation|GStreamer plugins]] required.
  
When using a different GTK theme than ''Adwaita'', LibreOffice may fail to start:
+
=== Default paper size in Writer and Draw ===
  
(soffice:2148): GLib-GObject-CRITICAL **: g_value_set_boxed: assertion 'G_VALUE_HOLDS_BOXED (value)' failed
+
If the default paper size in blank Writer and Draw documents is persistently incorrect for your locale, try installing the {{Pkg|libpaper}} optional dependency and either updating {{ic|/etc/papersize}} (for a system-wide change) or exporting the {{ic|PAPERSIZE}} environment variable (for a user change) with your preferred paper size. See {{man|5|papersize}}.
 
(soffice:2148): GLib-GObject-WARNING **: gtype.c:4268: type id '0' is invalid
 
 
(soffice:2148): GLib-GObject-WARNING **: can't peek value table for type '<invalid>' which is not currently referenced
 
Application Error
 
  
See {{Bug|46614}}.
+
{{Note|{{Pkg|libpaper}} defaults to '''Letter''' paper size if nothing else has been set.}}
  
=== Exit while pushing the save button ===
+
=== LibreOffice toolbars unreadable with dark themes ===
  
Try either of the following workarounds:
+
See https://bugs.documentfoundation.org/show_bug.cgi?id=94632
 +
 
 +
To use toolbar icons compatible with dark themes, set [[environment variable]] {{ic|1=VCL_ICONS_FOR_DARK_THEME=1}}
  
* Delete the {{ic|~/.config/libreoffice}} folder. It will erase all the settings linked to LibreOffice and so, LibreOffice will recreate them on the next launch.
+
As an alternative workaround, run ''libreoffice'' with a light theme (e.g. with environment variable {{ic|1=GTK_THEME=Adwaita:light}}).
  
* Go to menu Tools > Options > LibreOffice > General and check {{ic|Use LibreOffice dialogs}}.
+
=== LibreOffice toolbars unreadable with dark Breeze/Plasma 5 theme ===
  
* The GTK3 integration provided by {{ic|libvclplug_gtk3lo.so}} has been identified as the cause of this problem. [https://forums.opensuse.org/showthread.php/510439-LibreOffice-crashes-when-saving] See [[#Theme]] to use a different VCL, such as {{ic|gtk}}.
+
If you do not want to install {{Pkg|breeze-gtk}} change the icon style in ''Tools > Options > LibreOffice > View > Icon Style'' to a readable one provided by LibreOffice.
  
=== Media support ===
+
Otherwise [[install]] the Breeze theme for [[GTK]], {{Pkg|breeze-gtk}}.
  
If embedded videos are just gray boxes, make sure to have installed the [[GStreamer#Current version plugins|GStreamer plugins]] required.
+
Just enable "Breeze Dark" or another readable icon style in ''Tools > Options > LibreOffice > View > Icon Style'' then.
  
=== Default paper size in Writer and Draw ===
+
If that is not enough, ensure that LibreOffice starts using the {{ic|gtk}} interface - see [[#Theme]].
  
If the default paper size in blank Writer and Draw documents is persistently incorrect for your locale, try installing the {{pkg|libpaper}} optional dependency and either updating {{ic|/etc/papersize}} (for a system-wide change) or exporting the {{ic|PAPERSIZE}} environment variable (for a user change) with your preferred paper size.
+
If this still does not work correctly, try using the {{ic|gen}} interface instead. [https://bbs.archlinux.org/viewtopic.php?id=206813]
  
{{note|{{pkg|libpaper}} defaults to '''Letter''' paper size if nothing else has been set.}}
+
=== LibreOffice Math formula editor unreadable with dark theme ===
  
=== LibreOffice toolbars unreadable with dark themes ===
+
Text in formula editor is also unreadable if a dark theme is in use. There is an ongoing [https://bugs.documentfoundation.org/show_bug.cgi?id=90297 bug report].
  
See https://bugs.documentfoundation.org/show_bug.cgi?id=94632
+
Some have had success with overriding text color in LibreOffice preferences, but that changes text color everywhere, such as the document itself, which is still white.
  
To use toolbar icons compatible with dark themes, set [[environment variable]] {{ic|1=VCL_ICONS_FOR_DARK_THEME=1}}
+
Only workaround known is to override the theme to a light one (e.g. {{ic|1=GTK_THEME=Adwaita:light}}).
  
As an alternative workaround, run ''libreoffice'' with a light theme (e.g. with environment variable {{ic|1=GTK_THEME=Adwaita:light}}).
+
=== AutoText expected default behaviour not functional in system locales other than en_US ===
  
== LibreOffice Impress presentation won't show slideshow and notes on correctly on multidisplay setup ==
+
If expected default AutoText behaviour is not present (for example, typing {{ic|fn}} in a document in Writer and then pressing the {{ic|F3}} key does not result in the automatic insertion of a numbered function) when the system locale is not {{ic|en_US}} you need to add the default {{ic|en_US}} AutoText templates to your AutoText path. To do this, go to ''Tools > AutoText'', then click on ''Path...'' and add the following path to the list: {{ic|/usr/lib/libreoffice/share/autotext/en-US}}. AutoText should now work as expected by default.
  
Not sure if this is because of a bug or something, but if the slideshow won't show on your additional display in a multimonitor setup, you can add this to your i3 config file:
+
=== LibreOffice freezes ===
 +
Disable OpenCL and/or OpenGL by setting the [[environment variable]] {{ic|1=SAL_DISABLE_OPENCL=1}} and/or {{ic|1=SAL_DISABLEGL=1}}. The LibreOffice safe mode also offers the option to disable both.
  
    assign [class=".*libreoffice-impress.*"] 8
+
== See also ==
    workspace 8 output eDP1
 
    assign [class="Soffice"] 9
 
    workspace 9 output HDMI2
 
  
When starting the presentation, you can move the notes/slides-window to the main display, and the slideshow will be visible underneath. Make the slideshow fullscreen.
+
* [https://extensions.libreoffice.org/extensions Libreoffice Extensions]
 +
* [https://extensions.libreoffice.org/templates Libreoffice Templates]
 +
* [[Wikipedia:LibreOffice]]

Latest revision as of 19:45, 25 January 2020

From Home - LibreOffice:

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.

Installation

Install one of the following packages:

  • libreoffice-still is the stable maintenance branch, for conservative users.
  • libreoffice-fresh is the feature branch, with new program enhancements for early adopters or power users.
Note:

Check the optional dependencies pacman displays. If you use HSQLDB Embedded in LibreOffice Base, you must install a Java Runtime Environment. You may need hsqldb2-javaAUR to use some modules in LibreOffice Base.

Theme

LibreOffice includes support for GTK and Qt theme integration. See also Uniform look for Qt and GTK applications.

LibreOffice will try to autodetect the most suitable VCL UI interface based on your desktop environment. To force the use of a certain VCL UI interface, use one of the SAL_USE_VCLPLUGIN=gen, SAL_USE_VCLPLUGIN=kde5, or SAL_USE_VCLPLUGIN=gtk3 environment variables. These variables can be uncommented in /etc/profile.d/libreoffice-fresh.sh or /etc/profile.d/libreoffice-still.sh.

Note:
  • When using the LXDE desktop environment, setting SAL_USE_VCLPLUGIN in /etc/profile.d/libreoffice-fresh.sh has no effect since the SAL_USE_VCLPLUGIN environment variable is afterwards set to gtk by the script /usr/bin/startlxde. In order to use gtk3 toolkit with LXDE the SAL_USE_VCLPLUGIN environment variable needs to be set after launching the desktop environment. upstream bug
  • In LibreOffice 6.4, the kde5 backend will be renamed to kf5.

If you prefer to disable the startup logo, open /etc/libreoffice/sofficerc, find the Logo= line and set Logo=0.

Note: This variable is unrelated with the Logo scripting support.

Extension management

The following additional extensions are available:

For more extensions, check the AUR, the built-in LibreOffice Extension manager, or libreplanet.

Language aids

Spell checking

For spell checking, please make sure hunspell is properly installed; this should be the case for both still and fresh LibreOffice versions. Then install a language dictionary for hunspell like hunspell-en_US for American English or hunspell-de for German. Then enable the Writing aids by selecting the check-box in Tools > Options > Language Settings > Writing Aids > Hunspell SpellChecker after restarting LibreOffice.

Finnish

Unlike other languages, Finnish dictionaries use different naming. These four packages should be installed (in this order): libvoikko, malagaAUR, voikko-fiAUR, hfstospellAUR and voikko-libreofficeAUR.

Greek

Project Orthos provides more complete Greek spell checkers as Libreoffice extensions. Package libreoffice-extension-orthos-greek-dictionaryAUR provides a Greek-only spelling dictionary, while libreoffice-extension-orthos-greek-english-dictionaryAUR provides one that bundles Greek and US English.

Hyphenation rules

For hyphenation rules, you will need hyphen and a language hyphen rule set (hyphen-en for English, hyphen-de for German, etc).

Thesaurus

For the thesaurus option, you will need libmythes and a mythes language thesaurus (like mythes-en for English, mythes-de for German, etc).

Greek

For Greek, instead of mythes-elAUR you may want to try out libreoffice-extension-orthos-greek-thesaurusAUR, which includes more words.

Grammar checking

For grammar checking, several tools are available. The most common is LanguageTool. You can either:

After this extension has been installed, please make sure you have a Java 8 runtime installed (jre8-openjdk). Indeed, Languagetool uses Java and may slow down or briefly hang LibreOffice, particularly while opening documents. Fortunately this is usually only when initially opening a document and is usually not apparent otherwise. Once installed, you want to enable it as the default environment for LibreOffice. To do that go to "Tools" --> "Options" --> "Advanced" and select the appropiate JRE (it will be shown as 1.8.0) then press "Ok". You will be prompted to restart the LibreOffice suite. Once restarted you will be able to install Languagetools without trouble.

Other grammar tools can also be found on the LibrePlanet extension page, on the official LibreOffice Extensions website or OpenOffice's Website. Please note all OpenOffice extensions are guaranteed to work with LibreOffice.

French

French-speaking users are advantaged here: they do not need to install LanguageTool nor Java. Dicollecte provides a nice Python extension, specifically designed for Frenchs. You can install it from the website or via libreoffice-extension-grammalecte-frAUR. In any case, this extensions also comes with the French dictionaries otherwise provided by hunspell-fr.

Offline help

libreoffice-still and libreoffice-fresh provide the offline help files for en-US. Help files for different locales is provided by the appropriate libreoffice language package, (i.e., libreoffice-fresh-en-za provides the help files for en-ZA locales).

Installing macros

If you intend to use macros, you must have a Java Runtime Environment enabled.

The default path for macros in Arch Linux is different from most Linux distributions. Its location is: ~/.config/libreoffice/4/user/Scripts/.

Troubleshooting

A general way to track down problems is the safe mode in LibreOffice:

$ libreoffice --safe-mode

Font substitution

These settings can be changed in the LibreOffice options. From the drop-down menu, select Tools > Options > LibreOffice > Fonts. Check the box that says Apply Replacement Table. Type Andale Sans UI in the font box and choose your desired font for the Replace with option. When done, click the checkmark. Then choose the Always and Screen only options in the box below. Click OK. You will then need to go to Tools > Options > LibreOffice > View, and uncheck "Use system font for user interface". If you use a non-antialised font, such as Arial, you will also need to uncheck "Screen font antialiasing" before menu fonts render correctly.

Anti-aliasing

Merge-arrows-2.pngThis article or section is a candidate for merging with Font configuration.Merge-arrows-2.png

Notes: please use the second argument of the template to provide more detailed indications. (Discuss in Talk:LibreOffice#)

Execute:

$ echo "Xft.lcdfilter: lcddefault" | xrdb -merge

To make the change persistent, add Xft.lcdfilter: lcddefault to your ~/.Xresources file, and make sure to run $ xrdb -merge ~/.Xresources (source). See X resources for more details.

If this does not work, you can also try adding Xft.lcdfilter: lcddefault to your ~/.Xdefaults. If you do not have this file, you will have to create it.

Hanging when using NFSv3 shares

If LibreOffice hangs when trying to open or save a document located on a NFSv3 share, try prepending the following lines with a # in /usr/lib/libreoffice/program/soffice:

# file locking now enabled by default
SAL_ENABLE_FILE_LOCKING=1
export SAL_ENABLE_FILE_LOCKING

To avoid overwriting on update you can copy /usr/lib/libreoffice/program/soffice in /usr/local/bin. Original post here.

LibreOffice does not detect my certificates

If you cannot see the certificates when trying to sign a document, you will need to have the certificates configured in Mozilla Firefox (or Thunderbird). If after that LibreOffice still does not show them, set the MOZILLA_CERTIFICATE_FOLDER environment variable to point to your Mozilla Firefox (or Thunderbird) folder:

export MOZILLA_CERTIFICATE_FOLDER=$HOME/.mozilla/firefox/XXXXXX.default/

Certificate detection.

Run .pps files in edit mode (without slideshow)

The only solution is to rename the .pps file to .ppt.

Add the following script to your home directory and use it to open every .pps file. Very useful to open .pps files received by email without the need to save them.

#!/bin/bash

f=$(mktemp --suffix .ppt)
cp "$1" "${f}" && libreoffice "${f}" && rm -f "${f}"

Media support

If embedded videos are just gray boxes, make sure to have installed the GStreamer plugins required.

Default paper size in Writer and Draw

If the default paper size in blank Writer and Draw documents is persistently incorrect for your locale, try installing the libpaper optional dependency and either updating /etc/papersize (for a system-wide change) or exporting the PAPERSIZE environment variable (for a user change) with your preferred paper size. See papersize(5).

Note: libpaper defaults to Letter paper size if nothing else has been set.

LibreOffice toolbars unreadable with dark themes

See https://bugs.documentfoundation.org/show_bug.cgi?id=94632

To use toolbar icons compatible with dark themes, set environment variable VCL_ICONS_FOR_DARK_THEME=1

As an alternative workaround, run libreoffice with a light theme (e.g. with environment variable GTK_THEME=Adwaita:light).

LibreOffice toolbars unreadable with dark Breeze/Plasma 5 theme

If you do not want to install breeze-gtk change the icon style in Tools > Options > LibreOffice > View > Icon Style to a readable one provided by LibreOffice.

Otherwise install the Breeze theme for GTK, breeze-gtk.

Just enable "Breeze Dark" or another readable icon style in Tools > Options > LibreOffice > View > Icon Style then.

If that is not enough, ensure that LibreOffice starts using the gtk interface - see #Theme.

If this still does not work correctly, try using the gen interface instead. [1]

LibreOffice Math formula editor unreadable with dark theme

Text in formula editor is also unreadable if a dark theme is in use. There is an ongoing bug report.

Some have had success with overriding text color in LibreOffice preferences, but that changes text color everywhere, such as the document itself, which is still white.

Only workaround known is to override the theme to a light one (e.g. GTK_THEME=Adwaita:light).

AutoText expected default behaviour not functional in system locales other than en_US

If expected default AutoText behaviour is not present (for example, typing fn in a document in Writer and then pressing the F3 key does not result in the automatic insertion of a numbered function) when the system locale is not en_US you need to add the default en_US AutoText templates to your AutoText path. To do this, go to Tools > AutoText, then click on Path... and add the following path to the list: /usr/lib/libreoffice/share/autotext/en-US. AutoText should now work as expected by default.

LibreOffice freezes

Disable OpenCL and/or OpenGL by setting the environment variable SAL_DISABLE_OPENCL=1 and/or SAL_DISABLEGL=1. The LibreOffice safe mode also offers the option to disable both.

See also