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.
- 1 Installation
- 2 Theme
- 3 Speed up OpenOffice
- 4 Troubleshooting
- 4.1 Font substitution
- 4.2 Anti-aliasing
- 4.3 Spell checking problems
- 4.4 Dark GTK+ themes, icons and GTK-Qt Engine
- 4.5 Hanging when using NFSv3 shares
- 4.6 Fixing Java framework error
- 4.7 OpenOffice does not detect my certificates
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:
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
- Download the extension and install it using
/usr/lib/openoffice/program/unopkg add extensionfor the user
- Download the extension and install it using
/usr/lib/openoffice/program/unopkg add --shared extensionfor every user on the system (requires root permission)
For spellchecking you will needand dictionary for hunspell (like , , etc), for hyphenation rules you will need ( , , etc) and for a thesaurus, .
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
In most Linux distros, the default path for macros is:
The path for this directory in Arch Linux is:
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:
Install TrueType fonts
To add fonts to those already available in OpenOffice, run
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
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
You may wish to set the Xorg server dots-per-inch in the KDM configuration.
Do not select Use my KDE style in GTK applications. Instead choose a native syle and font for GTK+ 2 applications.
Use a program liketo 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:
- Set scale to 100%
- Set use system font OFF (otherwise replacement table will not be used)
- Set antialiasing OFF
- 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
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.
$ echo "Xft.lcdfilter: lcddefault" | xrdb -merge
To make the change persistent, add
Xft.lcdfilter: lcddefault to your
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:
Installand 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:
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
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.
Older OpenOffice versions (< 3.2.x)
- For a quick fix, see broken link: archived in aur-mirror]. This also sets
- Another fix is to export
SAL_USE_VCLPLUGIN=gen(generic X11). See for more info.
Newer OpenOffice / LibreOffice versions
In newer version of OpenOffice / LibreOffice ( > 3.2.x), the fixes mentioned above do not seem to work. 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.
If OpenOffice hangs when trying to open/save a document located on a NFSv3 share, try prepending the following lines with a
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
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
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.
See more about certificate detection.