Difference between revisions of "Apache OpenOffice"

From ArchWiki
Jump to navigation Jump to search
m (no more plus in gtk)
 
(208 intermediate revisions by 95 users not shown)
Line 1: Line 1:
[[Category:Office (English)]]
+
[[Category:Office]]
[[Category:HOWTOs (English)]]
+
[[Category:Apache]]
 +
[[cs:Apache OpenOffice]]
 +
[[el:Apache OpenOffice]]
 +
[[fr:Openoffice]]
 +
[[it:Apache OpenOffice]]
 +
[[ja:Apache OpenOffice]]
 +
[[ru:Apache OpenOffice]]
 +
[[th:Apache OpenOffice]]
 +
[[zh-hans:Apache OpenOffice]]
 +
{{Note|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)].}}
 +
From [http://why.openoffice.org/ Why Apache OpenOffice]:
  
{{i18n_links_start}}
+
:Apache OpenOffice is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.
{{i18n_entry|English|OpenOffice}}
 
{{i18n_entry|Ελληνικά|OpenOffice (Ελληνικά)}}
 
{{i18n_entry|简体中文|OpenOffice_(简体中文)}}
 
{{i18n_entry|Português|OpenOffice_(Português)}}
 
{{i18n_links_end}}
 
==Arch offers 3 different OpenOffice branches==
 
Arch offers 3 trees of binary packages for OpenOffice with different pkg names:
 
* openoffice-base
 
This will always be the last released stable version of OpenOffice. <br>
 
Current version: 2.4.1 <br>
 
start it with "soffice" or from Desktop menu <br>
 
spell checking packages and localisation packages will always belong to this package
 
* openoffice-base-beta
 
This packages will be only present when a new release is not far away. It will be the alpha, beta an release candidates packages for the next stable release. <br>
 
Current version: 3.0_ooo300_m2 (a version past 3.0 beta2 that will lead to stable 3.0 release) <br>
 
start it with "soffice-beta" or from Desktop menu <br>
 
It's safe to install it together with the stable and devel version.<br>
 
Please test it carefully and report upstream bugs to OpenOffice and packaging bugs in our flyspray <br>
 
see http://wiki.services.openoffice.org/wiki/OOoRelease30 for roadmap
 
* openoffice-base-devel
 
This packages will be updated from time to time and is a playground for the packager and for testing latest features. Please test and file upstream issues at http://www.openoffice.org/issues/query.cgi<br>
 
Current version: 3.0_dev300_m29 / snapshot DEV300_m29 (snapshots past branching the 3.0 stable tree that will lead to 3.1 release annd beyond) <br>
 
start it with "soffice-devel" or from Desktop menu <br>
 
It's safe to install it together with the stable and beta version
 
Attention: if you play with more than one openoffice-base version it's highly recommended to always backup your
 
configuration directory ~/.openoffice{2,3} !
 
==Installation==
 
* First, install a Java Runtime Environment (optional, highly recommended):
 
# pacman -S openjdk6 (still in testing) or
 
# pacman -S jre
 
* Download the base for stable and/or beta and/or devel:
 
# pacman -S openoffice-base openoffice-base-beta openoffice-base-devel
 
===language packages and spell checking for stable releases===
 
* Install one or more language packs. This is optional as English ''is'' already included in the base:
 
# pacman -S openoffice-XX (where XX is a language)
 
* Install spellchecker files (optional):
 
# pacman -S openoffice-spell-XX (where XX is a language)
 
  
* Spellcheckers and language packs for other languages can be found in [[AUR]]. File feature request in flyspray and try to get votes if you want a pkg to become officially supported in extra.
+
== Installation ==
===Set OOo environment variable===
 
OpenOffice2 introduced the ability to use several toolkits for drawing and integrates into different desktop environments in a clean way. To choose by hand, you need to set the OOO_FORCE_DESKTOP environment variable, either system-wise (like put it in /etc/profile, rc.local, or ~/.bashrc or something like /etc/profile.d/openoffice) or in the specific shell OpenOffice.org is running in (see message when you install/update openoffice-base).
 
  
To run OpenOffice.org in GTK2 mode, you can issue (using bash):
+
[[Install]] the {{AUR|openoffice}} package. It is recommended to also install [[Java]].
  # OOO_FORCE_DESKTOP=gnome soffice
 
To run OpenOffice.org in QT/KDE3 mode, you can issue (using bash):
 
  # OOO_FORCE_DESKTOP=kde soffice
 
  
KDE look will be removed in Openoffice3. It's highly recommended to export OOO_FORCE_DESKTOP=gnome for all users (yes, also under kde4) with versions from >=3.x or you will see soon glib/gtk related crashes.
+
=== Microsoft fonts ===
  
=== Adding media support to OpenOffice.org 2 ===
+
Official Microsoft fonts are useful to prevent pagination problems. Check the [[MS Fonts]] wiki page.
  
If you want to be able to use sound and video in OpenOffice.org Impress presentations, you need to install the [[Java Media Framework]] and [[Java_Media_Framework#Adding_media_support_to_OpenOffice.org|configure OpenOffice.org to use it]]
+
=== Extension management and spell checking ===
  
=== Manual dictionary installation ===
+
The Arch package is now shipped with some dictionaries. Check ''Extension manager'' if your language is already there simply by loading up any OpenOffice program (Writer for example) and access the ''Extension Manager'' from the Tools menu. From there enter the following location to install a spell check dictionary:
  
If you for some reason want to install dictionaries manually (e.g. there are no dictionary packages available in your language) follow these instructions:
+
/usr/lib/openoffice/share/extension/install/
* Download a dictionary pack for your language. A list of dictionaries is available at [http://wiki.services.openoffice.org/wiki/Dictionaries OOoDictionaries]
 
* Extract the dictionaries to /opt/openoffice/share/dict/ooo/
 
The necessary files are normally named like en_US.dic and en_US.aff for spellchecking, hyph_en_US.dic for hyphenation dictionaries, and th_en_US.dat and th_en_US.idx for the thesaurus files.
 
* Open /opt/openoffice/share/dict/ooo/dictionary.lst with your favorite text editor. Add the dictionaries to the list using the following rules:
 
  # List of All Dictionaries to be Loaded by OpenOffice
 
  # ---------------------------------------------------
 
  # Each Entry in the list have the following space delimited fields
 
  #
 
  # Field 1: Entry Type "DICT" - spellchecking dictionary
 
  # "HYPH" - hyphenation dictionary
 
  # "THES" - thesaurus files
 
  #
 
  # Field 2: Language code from Locale "en" or "de" or "pt" ...
 
  #
 
  # Field 3: Country Code from Locale "US" or "GB" or "PT"
 
  #
 
  # Field 4: Root name of file(s) "en_US" or "hyph_de" or "th_en_US
 
  # (do not add extensions to the name)
 
  
* An example using the American dictionaries would look like:
+
{{Note|If you installed LibreOffice, the path will be {{ic|/usr/lib/libreoffice/share/extensions/}} instead and extensions are currently all already known to the system.}}
  ### start en
 
  DICT en US en_US
 
  HYPH en US hyph_en_US
 
  THES en US th_en_US
 
  ### end en
 
* Save the file and restart OpenOffice. Make sure all the Openoffice processes is properly killed. Otherwise the newly installed dictionaries won't show up.
 
  
==Running==
+
Alternatively, there are several ways to accomplish this:
  
If you want to run a specific module of OpenOffice.org (instead of the soffice default), for example the word processor (Write), spreadsheet application (Calc) or presentation program (Impress), check for the following script front-ends:
+
* Use the ''Extension manager'' from OpenOffice menu for download and installation - installs only for the user into his {{ic|~/.openoffice.org/3/user/uno_packages/cache}}
 +
* Download the extension and install it using {{ic|/usr/lib/openoffice/program/unopkg add extension}} for the user
 +
* Download the extension and install it using {{ic|/usr/lib/openoffice/program/unopkg add --shared extension}} for every user on the system (requires root permission)
  
Writer
+
==== Spellchecker ====
  /opt/openoffice/program/swriter
 
  
Calc
+
For spellchecking you will need {{Pkg|hunspell}} and dictionary for hunspell (like {{Pkg|hunspell-en_US}}, {{Pkg|hunspell-de}}, etc), for hyphenation rules you will need {{Pkg|hyphen}} ({{Pkg|hyphen-en}}, {{Pkg|hyphen-de}}, etc) and for a thesaurus, {{Pkg|libmythes}}.
  /opt/openoffice/program/scalc
 
  
Impress
+
==== Other extensions installed by default ====
  /opt/openoffice/program/simpress
 
  
Math (Formula Editor)
+
* '''pdfimport.oxt''' - Ability to import PDF files in Draw and Impress
  /opt/openoffice/program/smath
+
* '''presenter-screen.oxt''' - When using two displays this plugin provides more control over slideshow
 +
* '''sun-presentation-minimizer.oxt''' - Reduce file size of current presentation
 +
* '''wiki-publisher.oxt''' - Allows to create Wiki articles on MediaWiki servers without having to know the syntax of the MediaWiki markup language
  
Base (Database frontend)
+
=== Installing macros ===
  /opt/openoffice/program/sbase
 
  
Printer Administration (Recommended to run as root)
+
In most Linux distros, the default path for macros is:
  /opt/openoffice/program/spadmin
+
~/.openoffice.org/3/user/Scripts/
 +
The path for this directory in Arch Linux is:
 +
~/.config/.openoffice.org/3/user/Scripts/
 +
Macros are not guaranted to work in both OpenOffice and LibreOffice, but it is possible to choose a common directory for them. Choose the path in ''Tools > Options > LibreOffice/OpenOffice > Paths''
 +
The default path for LibreOffice macros in Arch Linux is:
 +
~/.config/libreoffice/4/user/Scripts/
  
==Known Problems==
+
{{Note|If you intend to use macros, you must have a Java Runtime Environment. This behaviour is a default, but disabling it [[#Speed up OpenOffice|speeds up]] the loading time.}}
* extension handling in versions >=3.0
+
 
* qt look'n feel since kde4 release
+
=== Install TrueType fonts ===
 +
 
 +
To add fonts to those already available in OpenOffice, run {{ic|spadmin}}.
 +
 
 +
== Theme ==
 +
 
 +
OpenOffice supports to use several toolkits for drawing and integrates into different desktop environments in a clean way. To choose by hand, you need to set the {{ic|OOO_FORCE_DESKTOP}} environment variable. Its possible values are ''gnome'' and ''kde4''.
 +
 
 +
To configure the look for anytime OpenOffice gets started, you can export the {{ic|OOO_FORCE_DESKTOP}} variable in {{ic|/etc/profile.d/openoffice.sh}}, or in {{ic|/usr/bin/soffice}}.
 +
Alternatively you can put the variable in any OpenOffice desktop file in {{ic|Exec}} line between {{ic|Exec}} and the command, then copy them to {{ic|$XDG_DATA_HOME/applications}} in order to prevent overwriting on update.
 +
 
 +
=== KDE4/Qt4 look and feel ===
 +
 
 +
Check [[Uniform look for Qt and GTK applications]] for a broad application, general tips and other methods to achieve it.
 +
 
 +
==== Use different configuration from general theme ====
 +
 
 +
Do '''not''' select ''Use my KDE style in GTK applications''. Instead choose a native syle and font for GTK 2 applications.
 +
 
 +
Use a program like {{Pkg|gtk-chtheme}} to select a style (in general different from KDE) and a font (may be the same as your KDE general system font). There are also other GTK engine packages available.
 +
 
 +
There are two relevant parts of the OpenOffice options dialog, ''View'' and ''Fonts'':
 +
* '''View'''
 +
** Set scale to 100%
 +
** Set use system font OFF (otherwise replacement table will not be used)
 +
** Set antialiasing OFF
 +
 
 +
* '''Fonts'''
 +
** Select ''Use replacement table''
 +
** Replace ''Andale Sans UI'' (you '''must''' type this in -- it is not in the drop down list) with another font (your KDE system font or another if this looks bad)
 +
** Press the tick symbol to update the list
 +
** Select ''Always'' and ''Screen only''
 +
** Press ''OK''
 +
 
 +
When choosing fonts for OpenOffice note that the poor font rendering engine included in the package may not render a particular font in the same way as other apps on the desktop.
 +
 
 +
== Speed up OpenOffice ==
 +
 
 +
Some settings may improve OpenOffice'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 > Number of steps'' to a figure lower than 100, to something like 40 or 50 steps
 +
** Under ''Graphics cache'', set ''Use for OpenOffice'' to 128 MB (up from the original 20MB).
 +
** Set ''Memory per object'' to 20MB (up from the default 5MB)
 +
** If you use OpenOffice often, check ''OpenOffice Quickstarter''
 +
* Under ''Java'', uncheck Use a Java runtime environment
 +
{{Note|For a list of functionality which depends on OpenOffice Java support, see this page: http://wiki.services.openoffice.org/wiki/Java.}}
 +
 
 +
== Troubleshooting ==
 +
 
 +
=== Font substitution ===
 +
 
 +
These settings can be changed in the OpenOffice options. From the drop-down menu, select ''Tools > Options > OpenOffice > Fonts''. Check the box that says ''Apply Replacement Table''. Type {{ic|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 > OpenOffice > 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 ===
 +
 
 +
Execute:
 +
$ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
 +
 
 +
To make the change persistent, add {{ic|Xft.lcdfilter: lcddefault}} to your {{ic|~/.Xresources}} file[https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/271283/comments/19].
 +
 
 +
If this does not work, make sure you are running {{ic|$ xrdb -merge ~/.Xresources}} every time you launch [[Xorg]]. If you do not have this file, you will have to create it.
 +
 
 +
=== Spell checking problems ===
 +
 
 +
As of OpenOffice 3.0.0-2, various dictionaries may be buggy due to a character encoding problem. To solve this issue, follow the following instructions.
 +
 
 +
Find where the particular openoffice distribution places its dictionary files; e.g., {{ic|pacman -Ql openoffice-base}}. Most distibutions follow the convention of installing these to {{ic|/usr/lib/openoffice/share/extension/install}}. Once the directory has been found, assign it to a shell variable:
 +
droot="/usr/lib/openoffice/share/extension/install"
 +
 
 +
Install {{Pkg|unzip}} and {{Pkg|zip}} packages in order to be able to extract and compress the dictionary files.
 +
 
 +
For reference, get a list of languages whose dictionary files are packaged with the base distribution:
 +
cd "$droot" && ls | sed -rn 's,^dict-(..)\.oxt$,\1,p'
 +
 
 +
Define a list of languages whose dictionary files are to be fixed:
 +
lang="en es"
 +
 
 +
Extract the target languages' dictionary files and convert the erroneous encoding to ''UTF-8'':
 +
 
 +
{{bc|1=
 +
tmp="/tmp/dictfix-$USER-$$"
 +
 
 +
mkdir "$tmp"
 +
cd "$tmp"
 +
 
 +
for i in $lang; do
 +
    i="$droot/dict-$i.oxt"
 +
    unzip "$i" -d oxt.tmp
 +
    iconv -f ISO-8859-15 -t UTF-8 oxt.tmp/dictionaries.xcu > dict.tmp
 +
    mv dict.tmp oxt.tmp/dictionaries.xcu
 +
    (cd oxt.tmp && zip -r "$i" .)
 +
done
 +
 
 +
rm -rf "$tmp"
 +
}}
 +
 
 +
Finally, use the OpenOffice extension manager (available through the ''Tools'' menu) to install the dictionary from the resulting {{ic|dict-''xx''.oxt}} file(s).
 +
 
 +
=== Dark GTK themes, icons and GTK-Qt Engine ===
 +
 
 +
Older OpenOffice/LibreOffice versions would start in ''High Contrast Mode'' if you use dark [[GTK]] themes. This might prevent you from changing ''High Contrast Icons'' or Calc cell background coloring is completely disabled.
 +
 
 +
In newer version of OpenOffice / LibreOffice ( > 3.2.x), possible solutions may be:
 +
 
 +
* You could manually configure UI colors via ''Tools > Options > Appearance'', yet Impress and Calc may stay dark.
 +
* Another solution is to disable ''Automatically detect high-contrast mode of operation system'' in ''LibreOffice > Accessibility'' (> LO 4.1.x).
 +
 
 +
Now the colors can be configured in ''Options > Appearance'' and the selection of another iconset is possible again.
 +
 
 +
=== Hanging when using NFSv3 shares ===
 +
 
 +
If OpenOffice hangs when trying to open/save a document located on a NFSv3 share, try prepending the following lines with a {{ic|#}} in {{ic|/usr/lib/openoffice/program/soffice}}.:
 +
 
 +
SAL_ENABLE_FILE_LOCKING=1
 +
export SAL_ENABLE_FILE_LOCKING
 +
 
 +
If you wish to avoid {{ic|/usr/lib/openoffice/program/soffice}} overwriting on update just copy it 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 OpenOffice:
 +
 
 +
[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.]
 +
 
 +
=== OpenOffice 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 Firefox (or Thunderbird). If after that OpenOffice still does not show them, set the {{ic|MOZILLA_CERTIFICATE_FOLDER}} environment variable pointing to your Firefox (or Thunderbird) folder.
 +
 
 +
export MOZILLA_CERTIFICATE_FOLDER=$HOME/.mozilla/firefox/XXXXXX.default/
 +
 
 +
See more about [http://wiki.openoffice.org/wiki/Certificate_Detection certificate detection].

Latest revision as of 19:24, 15 August 2019

Note: 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 Dropping Oracle OpenOffice (arch-general).

From Why Apache OpenOffice:

Apache OpenOffice is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.

Installation

Install the openofficeAUR package. It is recommended to also install Java.

Microsoft fonts

Official Microsoft fonts are useful to prevent pagination problems. Check the MS Fonts wiki page.

Extension management and spell checking

The Arch package is now shipped with some dictionaries. Check Extension manager if your language is already there simply by loading up any OpenOffice program (Writer for example) and access the Extension Manager from the Tools menu. From there enter the following location to install a spell check dictionary:

/usr/lib/openoffice/share/extension/install/
Note: If you installed LibreOffice, the path will be /usr/lib/libreoffice/share/extensions/ instead and extensions are currently all already known to the system.

Alternatively, there are several ways to accomplish this:

  • Use the Extension manager from OpenOffice menu for download and installation - installs only for the user into his ~/.openoffice.org/3/user/uno_packages/cache
  • Download the extension and install it using /usr/lib/openoffice/program/unopkg add extension for the user
  • Download the extension and install it using /usr/lib/openoffice/program/unopkg add --shared extension for every user on the system (requires root permission)

Spellchecker

For spellchecking you will need hunspell and dictionary for hunspell (like hunspell-en_US, hunspell-de, etc), for hyphenation rules you will need hyphen (hyphen-en, hyphen-de, etc) and for a thesaurus, libmythes.

Other extensions installed by default

  • pdfimport.oxt - Ability to import PDF files in Draw and Impress
  • presenter-screen.oxt - When using two displays this plugin provides more control over slideshow
  • sun-presentation-minimizer.oxt - Reduce file size of current presentation
  • wiki-publisher.oxt - Allows to create Wiki articles on MediaWiki servers without having to know the syntax of the MediaWiki markup language

Installing macros

In most Linux distros, the default path for macros is:

~/.openoffice.org/3/user/Scripts/

The path for this directory in Arch Linux is:

~/.config/.openoffice.org/3/user/Scripts/

Macros are not guaranted to work in both OpenOffice and LibreOffice, but it is possible to choose a common directory for them. Choose the path in Tools > Options > LibreOffice/OpenOffice > Paths The default path for LibreOffice macros in Arch Linux is:

~/.config/libreoffice/4/user/Scripts/
Note: If you intend to use macros, you must have a Java Runtime Environment. This behaviour is a default, but disabling it speeds up the loading time.

Install TrueType fonts

To add fonts to those already available in OpenOffice, run spadmin.

Theme

OpenOffice supports to use several toolkits for drawing and integrates into different desktop environments in a clean way. To choose by hand, you need to set the OOO_FORCE_DESKTOP environment variable. Its possible values are gnome and kde4.

To configure the look for anytime OpenOffice gets started, you can export the OOO_FORCE_DESKTOP variable in /etc/profile.d/openoffice.sh, or in /usr/bin/soffice. Alternatively you can put the variable in any OpenOffice desktop file in Exec line between Exec and the command, then copy them to $XDG_DATA_HOME/applications in order to prevent overwriting on update.

KDE4/Qt4 look and feel

Check Uniform look for Qt and GTK applications for a broad application, general tips and other methods to achieve it.

Use different configuration from general theme

Do not select Use my KDE style in GTK applications. Instead choose a native syle and font for GTK 2 applications.

Use a program like gtk-chtheme to select a style (in general different from KDE) and a font (may be the same as your KDE general system font). There are also other GTK engine packages available.

There are two relevant parts of the OpenOffice options dialog, View and Fonts:

  • View
    • Set scale to 100%
    • Set use system font OFF (otherwise replacement table will not be used)
    • Set antialiasing OFF
  • Fonts
    • Select Use replacement table
    • Replace Andale Sans UI (you must type this in -- it is not in the drop down list) with another font (your KDE system font or another if this looks bad)
    • Press the tick symbol to update the list
    • Select Always and Screen only
    • Press OK

When choosing fonts for OpenOffice note that the poor font rendering engine included in the package may not render a particular font in the same way as other apps on the desktop.

Speed up OpenOffice

Some settings may improve OpenOffice'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 > Number of steps to a figure lower than 100, to something like 40 or 50 steps
    • Under Graphics cache, set Use for OpenOffice to 128 MB (up from the original 20MB).
    • Set Memory per object to 20MB (up from the default 5MB)
    • If you use OpenOffice often, check OpenOffice Quickstarter
  • Under Java, uncheck Use a Java runtime environment
Note: For a list of functionality which depends on OpenOffice Java support, see this page: http://wiki.services.openoffice.org/wiki/Java.

Troubleshooting

Font substitution

These settings can be changed in the OpenOffice options. From the drop-down menu, select Tools > Options > OpenOffice > 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 > OpenOffice > 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

Execute:

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

To make the change persistent, add Xft.lcdfilter: lcddefault to your ~/.Xresources file[1].

If this does not work, make sure you are running $ xrdb -merge ~/.Xresources every time you launch Xorg. If you do not have this file, you will have to create it.

Spell checking problems

As of OpenOffice 3.0.0-2, various dictionaries may be buggy due to a character encoding problem. To solve this issue, follow the following instructions.

Find where the particular openoffice distribution places its dictionary files; e.g., pacman -Ql openoffice-base. Most distibutions follow the convention of installing these to /usr/lib/openoffice/share/extension/install. Once the directory has been found, assign it to a shell variable:

droot="/usr/lib/openoffice/share/extension/install"

Install unzip and zip packages in order to be able to extract and compress the dictionary files.

For reference, get a list of languages whose dictionary files are packaged with the base distribution:

cd "$droot" && ls | sed -rn 's,^dict-(..)\.oxt$,\1,p'

Define a list of languages whose dictionary files are to be fixed:

lang="en es"

Extract the target languages' dictionary files and convert the erroneous encoding to UTF-8:

tmp="/tmp/dictfix-$USER-$$"

mkdir "$tmp"
cd "$tmp"

for i in $lang; do
    i="$droot/dict-$i.oxt"
    unzip "$i" -d oxt.tmp
    iconv -f ISO-8859-15 -t UTF-8 oxt.tmp/dictionaries.xcu > dict.tmp
    mv dict.tmp oxt.tmp/dictionaries.xcu
    (cd oxt.tmp && zip -r "$i" .)
done

rm -rf "$tmp"

Finally, use the OpenOffice extension manager (available through the Tools menu) to install the dictionary from the resulting dict-xx.oxt file(s).

Dark GTK themes, icons and GTK-Qt Engine

Older OpenOffice/LibreOffice versions would start in High Contrast Mode if you use dark GTK themes. This might prevent you from changing High Contrast Icons or Calc cell background coloring is completely disabled.

In newer version of OpenOffice / LibreOffice ( > 3.2.x), possible solutions may be:

  • You could manually configure UI colors via Tools > Options > Appearance, yet Impress and Calc may stay dark.
  • Another solution is to disable Automatically detect high-contrast mode of operation system in LibreOffice > Accessibility (> LO 4.1.x).

Now the colors can be configured in Options > Appearance and the selection of another iconset is possible again.

Hanging when using NFSv3 shares

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

SAL_ENABLE_FILE_LOCKING=1
export SAL_ENABLE_FILE_LOCKING

If you wish to avoid /usr/lib/openoffice/program/soffice overwriting on update just copy it in /usr/local/bin. Original post here.

Fixing Java framework error

You may get the following error when you try to run OpenOffice:

[Java framework] Error in function createSettingsDocument (elements.cxx).
javaldx failed!

If so, give yourself ownership of ~/.config/ like so:

# chown -vR username:users ~/.config

Post on Arch Linux Forums.

OpenOffice 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 Firefox (or Thunderbird). If after that OpenOffice still does not show them, set the MOZILLA_CERTIFICATE_FOLDER environment variable pointing to your Firefox (or Thunderbird) folder.

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

See more about certificate detection.