Difference between revisions of "LibreOffice"

From ArchWiki
Jump to: navigation, search
(Grammar checking: rm FUD, openjdk6 is not even available on Arch anymore)
(Read the note in Pacman#Installing_packages, this is an optdepend like any other)
 
(117 intermediate revisions by 43 users not shown)
Line 8: Line 8:
 
[[ru:LibreOffice]]
 
[[ru:LibreOffice]]
 
[[zh-CN:LibreOffice]]
 
[[zh-CN:LibreOffice]]
{{Article summary start}}
+
{{Related articles start}}
{{Article summary text|This article discusses the installation and configuration of LibreOffice}}
+
{{Related|Apache OpenOffice}}
{{Article summary heading|Related}}
+
{{Related|Unoconv}}
{{Article summary wiki|Apache OpenOffice}}: Apache branch-out of OpenOffice.org, the project from which LibreOffice descends.
+
{{Related articles end}}
{{Article summary end}}
+
 
 
From [http://www.libreoffice.org/ Home - LibreOffice]:
 
From [http://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. [http://www.libreoffice.org/get-help/ Support] and [http://www.libreoffice.org/get-help/documentation/ documentation] is free from our large, dedicated community of users, contributors and developers. [http://www.libreoffice.org/get-involved/ You, too, can also get involved!]''
+
:''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 in Arch Linux ==
+
== Installation ==
  
Official support for [[OpenOffice.org]] was dropped in favor of LibreOffice, the "Document Foundation" fork of the project, which also includes enhancements and additional features. See [https://mailman.archlinux.org/pipermail/arch-general/2011-March/018819.html Dropping Oracle OpenOffice (arch-general)].
+
[[Install]] one of the following packages from the [[official repositories]]:
  
== Installation ==
+
* {{Pkg|libreoffice-fresh}} is the feature branch, with new program enhancements.
 
+
* {{Pkg|libreoffice-still}} is the maintenance branch.
LibreOffice is split into several packages, which can be [[pacman|installed]] with the {{Grp|libreoffice}} group from the [[official repositories]]: pacman will display a menu prompting for which components and language packs to install.
+
  
 
{{Note|
 
{{Note|
* You will need to install at least 1 language pack. The default language is Afrikaans (because it is alphabetically the first provider of libreoffice-langpack). If you want the UK-English language pack, install {{Pkg|libreoffice-en-GB}}, not {{Pkg|libreoffice-uk}} (Ukrainian) or {{Pkg|libreoffice-br}} (Breton)!
+
* 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.
* You need {{Pkg|libreoffice-kde4}} or {{Pkg|libreoffice-gnome}} only if you care about Qt or GTK+ visual integration. See the [[#Theme|Theme]] section.
+
* 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 Qt and GTK+ visual integration, see [[#Theme]].
 
}}
 
}}
  
Check the recommended optional dependencies pacman suggests. E.g. install a Java Runtime Environment (optional, highly recommended). See: [[Java]]. You may need {{AUR|hsqldb2-java}} to use [https://wiki.documentfoundation.org/Base#Java_and_HSQLDB some module] of LibreOffice Base.
+
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.
 
+
=== Microsoft fonts ===
+
 
+
Official Microsoft fonts are useful to prevent pagination problems. Check the [[MS Fonts]] wiki page.
+
  
 
== 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]].
  
For [[Qt]] integration, install the package {{Pkg|libreoffice-kde4}}.
+
As of LibreOffice v3.5.x toolkit libraries are checked in the following order:
For [[GTK+]] integration, install the package {{Pkg|libreoffice-gnome}}.
+
{{Note|
+
* Qt integration is able to mimic GTK+ theme. The command {{ic|qtconfig-qt4}} opens a window which let you choose.
+
* Even if you are not running one of these desktop environments and thus do not need to "integrate" with them, you may still wish to install these packages so that LibreOffice will use non-default GTK+ or Qt themes. For example, LibreOffice on e17 uses the default "ugly" (aka "win95"/"win98") theme; installing libreoffice-gnome will allow you to select a more pleasant GTK+ theme.
+
}}
+
  
As of LibreOffice version 3.5.x it tries to magically autodetect your desktop UI using the following magic if proper libs will be found:
+
  gtk3 > gtk > kde4 > generic
  gtk > kde4 > generic
+
  
To force the use of a certain VCL UI interface use one of this:
+
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}}.
SAL_USE_VCLPLUGIN=gen lowriter
+
SAL_USE_VCLPLUGIN=kde4 lowriter
+
SAL_USE_VCLPLUGIN=gtk lowriter
+
SAL_USE_VCLPLUGIN=gtk3 lowriter
+
It is convenient to save {{ic|SAL_USE_VCLPLUGIN}} variable in your shell configuration file, e.g.{{ic|/etc/bash.bashrc}} or {{ic|~/.bashrc}} if using Bash.
+
  
{{Note|The new GTK3 UI is still marked upstream as experimental and will only be available if you enable "experimental features" in LibreOffice main configuration dialog.}}
+
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".
  
However, if it looks like it's 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".
+
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").
 
+
If that doesn't work immediately, you may need to change the icon set that's 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 ===
 
=== Firefox themes ===
  
LibreOffice 4.x series is able to use 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.
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 ===
  
If you prefer to disable the statup logo, open {{ic|/etc/libreoffice/sofficerc}}, find the {{ic|1=Logo=}} line and set {{ic|1=Logo=0}}.
+
If you prefer to disable the startup logo, open {{ic|/etc/libreoffice/sofficerc}}, find the {{ic|1=Logo=}} line and set {{ic|1=Logo=0}}.
 +
 
 
{{Note|This variable is unrelated with the Logo scripting support.}}
 
{{Note|This variable is unrelated with the Logo scripting support.}}
  
 
== Extension management ==
 
== Extension management ==
  
Arch is shipping some additional extensions from the [[official repositories]]:
+
The following additional extensions are available in the [[official repositories]]:
  
* {{Pkg|libreoffice-extension-nlpsolver}}
+
*{{Pkg|libreoffice-extension-texmaths}}
* {{Pkg|libreoffice-extension-presentation-minimizer}}
+
*{{Pkg|libreoffice-extension-writer2latex}}
* {{Pkg|libreoffice-extension-wiki-publisher}}
+
  
Check the [[AUR]] or the built-in LibreOffice Extension manager or [http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List get extensions online] if you want to install more extensions.
+
For more extensions, check the [[AUR]], the built-in LibreOffice Extension manager, or [http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List libreplanet].
  
 
== Language aids ==
 
== Language aids ==
Line 85: Line 72:
 
=== Spell checking ===
 
=== Spell checking ===
  
For spell checking, you will need {{Pkg|hunspell}} and a language dictionary for hunspell (like {{Pkg|hunspell-en}} for English, {{Pkg|hunspell-de}} for German, etc).
+
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''.
 +
 
 +
;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}}{{Broken package link|package not found}}, {{AUR|hfstospell}} and {{AUR|voikko-libreoffice}}.
  
 
=== Hyphenation rules ===
 
=== Hyphenation rules ===
Line 97: Line 87:
 
=== Grammar checking ===
 
=== Grammar checking ===
  
For grammar checking, you will need to install an extension such as LanguageTool, which can be found in the [[AUR]]: {{AUR|libreoffice-extension-languagetool}} or the [http://www.languagetool.org/ LanguageTool Website].
+
{{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].}}
  
Other grammar tools can also be found on the [http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List LibreOffice Extension Page] or [http://lingucomponent.openoffice.org/grammar.html OpenOffice's Website]. Not all OpenOffice extensions are guaranteed to work with LibreOffice.
+
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.
  
{{Note|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 package 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.
 +
 
 +
;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}}.
 +
 
 +
=== Offline help for en-US ===
 +
 
 +
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).
  
 
== 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 [[LibreOffice#Speed_up_LibreOffice|speeds up the program]].
+
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]].
  
 
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:
Line 117: Line 116:
 
** Under ''Graphics cache'', set Use for LibreOffice to 128 MB (up from the original 20 MB)
 
** 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).
 
** Set ''Memory per object'' to 20 MB (up from the default 5 MB).
** If you use LibreOffice often, check ''Enable systray Quickstarter''
+
** If LibreOffice is used often, check ''Enable systray Quickstarter''
{{Note|You need to have the package {{Pkg|libreoffice-gnome}} installed for the quickstarter option to be available.}}
+
 
* Under ''Advanced'', uncheck ''Use a Java runtime environment''
 
* 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.}}
 
{{Note|For a list of functionality written in Java only, see: https://wiki.documentfoundation.org/Development/Java.}}
Line 131: Line 129:
 
=== Anti-aliasing ===
 
=== Anti-aliasing ===
  
 +
{{Merge|Font configuration}}
 
Execute:
 
Execute:
 
  $ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
 
  $ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
Line 146: Line 145:
  
 
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://www.crazysquirrel.com/computing/debian/bugs/openoffice-over-nfs.jspx here].
 
=== Fixing Java framework error ===
 
 
You may get the following error when you try to run LibreOffice.
 
 
[Java framework] Error in function createSettingsDocument (elements.cxx).
 
javaldx failed!
 
 
If so, give yourself ownership of {{ic|~/.config/}} like so:
 
# chown -vR username:users ~/.config
 
 
[https://bbs.archlinux.org/viewtopic.php?id=93168 Post on Arch Linux forums].
 
  
 
=== LibreOffice does not detect my certificates ===
 
=== LibreOffice does not detect my certificates ===
Line 168: Line 155:
 
=== Run .pps files in edit mode (without slideshow) ===
 
=== Run .pps files in edit mode (without slideshow) ===
  
The only solution is to rename {{ic|.pps}} file in {{ic|.ppt}}.
+
The only solution is to rename the {{ic|.pps}} file to {{ic|.ppt}}.
  
 
Add the following script to your home directory and use it to open every .pps file. Very useful to open {{ic|.pps}} files received by email without the need to save them.
 
Add the following script to your home directory and use it to open every .pps file. Very useful to open {{ic|.pps}} files received by email without the need to save them.
Line 179: Line 166:
 
</nowiki>}}
 
</nowiki>}}
  
=== Bibliography problems ===
+
=== Application Error (not starting) ===
  
If Writer crashes on attempting to access ''Tools > Bibliography Database'', with the following error:
+
When using a different GTK theme than ''Adwaita'', LibreOffice may fail to start:
  com::sun::star::loader::CannotActivateFactoryException
+
 
Install {{Pkg|libreoffice-base}} as this is a workaround to a known bug, purportedly [http://cgit.freedesktop.org/libreoffice/core/commit/?id=1889c1af41650576a29c587a0b2cdeaf0d297587 fixed].
+
  (soffice:2148): GLib-GObject-CRITICAL **: g_value_set_boxed: assertion 'G_VALUE_HOLDS_BOXED (value)' failed
 +
 +
(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}}.
 +
 
 +
=== Exit while pushing the save button ===
 +
 
 +
Try either of the following workarounds:
 +
 
 +
* 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.
 +
 
 +
* Go to menu Tools > Options > LibreOffice > General and check {{ic|Use LibreOffice dialogs}}.
 +
 
 +
* 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}}.
  
 
=== Media support ===
 
=== Media support ===
Line 189: Line 193:
 
If embedded videos are just gray boxes, make sure to have installed the [[GStreamer#Current version plugins|GStreamer plugins]] required.
 
If embedded videos are just gray boxes, make sure to have installed the [[GStreamer#Current version plugins|GStreamer plugins]] required.
  
=== Content not resizing with windows on Xfwm4 ===
+
=== 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 {{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.
 +
 
 +
{{note|{{pkg|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]] {{ic|1=VCL_ICONS_FOR_DARK_THEME=1}}
 +
 
 +
As an alternative workaround, run ''libreoffice'' with a light theme (e.g. with environment variable {{ic|1=GTK_THEME=Adwaita:light}}).
 +
 
 +
=== LibreOffice toolbars unreadable with dark Breeze/Plasma 5 theme ===
 +
 
 +
[[Install]] the Breeze theme for [[GTK+]], {{Pkg|breeze-gtk}} and the Breeze dark icons for LibreOffice, {{AUR|libreoffice-breeze-icons}}.
 +
 
 +
Then ensure that LibreOffice starts using the {{ic|gtk}} interface - see [[#Theme]].
  
If you do not get the content of the LibreOffice window resize along with it under Xfce (or just using Xfwm4), like in this post: [https://bbs.archlinux.org/viewtopic.php?id=133137]. Install {{Pkg|libreoffice-gnome}} to solve the issue.
+
If this does not work correctly, try using the {{ic|gen}} interface instead. [https://bbs.archlinux.org/viewtopic.php?id=206813]

Latest revision as of 11:55, 2 December 2016

Related articles

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 from the official repositories:

Note:

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 hsqldb2-javaAUR to use some modules in LibreOffice Base.

Theme

Tango-view-refresh-red.pngThis article or section is out of date.Tango-view-refresh-red.png

Reason: With version 5.0, GTK3 is the default, it isn't completely working however. (Discuss in Talk:LibreOffice#)

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:

gtk3 > gtk > kde4 > generic

To force the use of a certain VCL UI interface, use one of the SAL_USE_VCLPLUGIN=gen, SAL_USE_VCLPLUGIN=kde4, SAL_USE_VCLPLUGIN=gtk 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.

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".

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 Mozilla's theme repository.

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 in the official repositories:

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 for English, hunspell-de for German, etc. Then enable the Writing aids by selecting the check-box in Tools -> Options -> Language Settings -> Writing Aids -> Hunspell SpellChecker.

Finnish

Unlike other languages, Finnish dictionaries use different naming. These four packages should be installed (in this order): libvoikko, malagaAUR, voikko-fi-malagaAUR[broken link: package not found], hfstospellAUR and voikko-libreofficeAUR.

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).

Grammar checking

Tango-inaccurate.pngThe factual accuracy of this article or section is disputed.Tango-inaccurate.png

Reason: Unintelligible flow of ideas: "...the later is not packaged..." -- which one is "the later"? I can only say that LanguageTool is packaged as a LibreOffice extension. (Discuss in Talk:LibreOffice#)

For grammar checking, several tools are available. The most common is LanguageTool. While the 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 libreoffice-extension-languagetoolAUR 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 languagetool package.

After this package 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 this AUR package: libreoffice-extension-grammalecte-frAUR. In any case, this extensions also comes with the French dictionaries otherwise provided by hunspell-fr.

Offline help for en-US

As of version 5.2.2, 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., 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. A Java Runtime Environment is enabled by default, but disabling it speeds up the program.

The default path for macros in Arch Linux is different from most Linux distributions. Its location is:

~/.config/libreoffice/4/user/Scripts/

Speed up LibreOffice

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.

  • 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

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)
cp "$1" "${f}.ppt" && libreoffice "${f}.ppt" && rm -f "${f}.ppt"

Application Error (not starting)

When using a different GTK theme than Adwaita, LibreOffice may fail to start:

(soffice:2148): GLib-GObject-CRITICAL **: g_value_set_boxed: assertion 'G_VALUE_HOLDS_BOXED (value)' failed

(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 FS#46614.

Exit while pushing the save button

Try either of the following workarounds:

  • Delete the ~/.config/libreoffice folder. It will erase all the settings linked to LibreOffice and so, LibreOffice will recreate them on the next launch.
  • Go to menu Tools > Options > LibreOffice > General and check Use LibreOffice dialogs.
  • The GTK3 integration provided by libvclplug_gtk3lo.so has been identified as the cause of this problem. [1] See #Theme to use a different VCL, such as gtk.

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.

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

Install the Breeze theme for GTK+, breeze-gtk and the Breeze dark icons for LibreOffice, libreoffice-breeze-iconsAUR.

Then ensure that LibreOffice starts using the gtk interface - see #Theme.

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