OpenOffice.org Extensions

July 14th, 2006 by Bruce Byfield

Your rating: None Average: 3.5 (2 votes)

OpenOffice.org extensions are a quick way to add functionality. Writable in a variety of languages, including Java, JavaScript, OpenOffice.org Basic, Python, and C++, they allow developers to contribute features without having to master much of OpenOffice.org's notoriously cryptic source code. For users, they provide quick fixes for commonly requested features.

For some reason, OpenOffice.org extensions have yet to capture developers' imaginations the way that Firefox extensions have. For every OpenOffice.org extension, there must be 20 or 30 for Firefox. Still, the few that exist are worth a look. In several cases, they provide small bits of functionality that users often request on the project's mail forums. Others fulfill specialized needs that OpenOffice.org hasn't addressed yet.

Those who wish to write extensions can find the information to get them started on the OpenOffice.org wiki. For those who are mainly consumers of developer's efforts, what follows is a description of how to use extensions, and a sampling of what's available.


Working with extensions

The best source for OpenOffice.org extensions is the repository page of the project's wiki. Extensions are packaged as zip files, and are generally small enough that they can be quickly downloaded, even with a dialup Internet connection.

To add an extension, start OpenOffice.org and select Tools > Package Manager. The Package Manager window shows two tree views: My Packages for extensions added only for the current user account, and OpenOffice.org Packages for extensions added by the root user for all accounts. Select one of these trees, then click the Add button and navigate to a downloaded extension. If the extension is added to the current user account, it is copied to ~/.openoffice.org2/user/uno_packages in the account's home directory. If the extension is added to all accounts, it is unpacked to ~/share/uno_packages in the base OpenOffice.org installation, which is generally in /opt, but may be elsewhere in other distributions. In Debian, for example, it's in /usr/lib/openoffice. Regardless of the location, once the extension is unpacked, it is listed in the Package Manager window and you can delete the downloaded zip file.

By default, added extensions are enabled. However, if an error occurs during installation, you may need to select it and click the Enabled button to make it available. You may also need to use both the Disable button to keep two or more conflicting extensions from being enabled at the same time. Extensions should also be disabled before they are removed. Otherwise, OpenOffice.org freezes and has to be killed and restarted.

Most changes to extensions occur on the fly. However, if you remove an extension, its menu items or toolbar buttons continue to be displayed until you quit all current documents. You don't have to restart OpenOffice.org -- just close everything until only the basic gray window is the only one that displays.


A selection of extensions

Here's a few of the extensions I've found most useful. All the extensions mentioned are available from the OpenOffice.org repository unless otherwise indicated:

  • History Manager: Messages on the OpenOffice.org User list used to frequently ask how to increase the number of recent documents displayed in Writer. This request is less frequent since version 2.0 increased the list of recent documents to ten, but still occurs. History manager adds a sub-menu item to Tools > Add-ons for changing the size of the list. It also includes a field for changing the Undo steps, although the same function is available from Tools > Options > OpenOffice.org > Memory. The extension removes the need to edit core files to change the recent document list, but probably you'll want it only until you are confident that the changed size does not slow down the program significantly. After that, you can disable or remove it.
  • OOo Blogger: These days, every word processor and text editor seems to be adding blog posting tools, and OpenOffice.org is no exception. OOo Blogger adds a Blog menu for posting new entries and editing old ones, with fields for entering the user name, password, and URL.
  • LanguageTool: One of the major gaps in OpenOffice.org Writer is a grammar checker. Although many point out that, if you know enough to use a grammar checker without being lured into even more errors, then you don't need one, the demand for one remains high on the User list. LanguageTool is a first effort to provide a grammar checker for English, German, and Polish. The English configuration checks by default for over 70 common grammatical errors and typos on either the entire document or selected text. While the response time is a little slow, in general LanguageTool performs about as well as any grammar checker -- that is, it catches small errors quickly, and can sometimes frustrate you with irrelevant queries. Its only drawback is that it requires Java 1.5.0, which free software supporters may not want to install.
  • OOo Wikipedia: Not included in OpenOffice.org's extension repository, OOo Wikipedia is OpenOffice.org's answer to MS Word's link to Encarta. OOo Wikipedia consists of two toolbar buttons, one of which opens your desktop's default web browser in an article on the nearest word to the cursor in the language of your choice, and one of which does the same for a selected word. For researchers, OOo Wikipedia is invaluable, especially if you are doing an on-line article and need a link for readers who may need some background. It's such a handy tool that Debian includes it by default in its OpenOffice.org packages. The one problem is that, when LanguageTool is enabled, OOo Wikipedia becomes non-functional, so you can't use both at once.

This list is by no means exhaustive. However, it's enough to give a sense of the variety of functions that extensions can offer.


Waiting for functionality

Whether you can use an extension may depend on what version of OpenOffice.org you are using. For instance, in Debian, OpenOffice.org files are repositioned to conform to Debian standards, so if you use the Debian OpenOffice.org packages, extensions that require the paths used by the standard OpenOffice.org packages may fail. That seems to be the case with OOo Multisave, a useful tool for simultaneously saving files in different formats. If you really want such extensions, you can probably rewrite them once you research how the paths have changed. Alternatively, you can use the packages available from the OpenOffice.org site, converting them to .debs if necessary using alien.

Another option may be to wait for another OpenOffice.org version. In the past, macros for installing new fonts and dictionary files written by Laurent Godard, Extensions Lead for the project and the creator of OOo Wikipedia, have found their way into new releases, and it's likely that some extensions will follow the same path in the future. OOo Wikipedia, for one, seems likely to do so, since it adds a feature that MS Word has and OpenOffice.org Writer currently lacks. Others may not, either because they are low priority or for some other reason. But perhaps the biggest point of extensions is that you don't have to wait -- they're available as soon as someone (maybe you) see a need.


Bruce Byfield is a computer journalist who writes regularly for the Newsforge and Linux Journal sites.

__________________________
--
Bruce Byfield (nanday)


Special Magazine Offer -- Free Gift with Subscription
Receive a free digital copy of Linux Journal's System Administration Special Edition as well as instant online access to current and past issues. CLICK HERE for offer

Linux Journal: delivering readers the advice and inspiration they need to get the most out of their Linux systems since 1994.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Thorsten Bosbach's picture

New OpenOffice.org Extensions Website

On November 8th, 2007 Thorsten Bosbach (not verified) says:

There is now an 'interactive' OpenOffice.org Extensions website at http://extensions.services.openoffice.org/
Which is a little bit more eye pleasent than the list in the wiki.
The site is also based on drupal, like this one :-)

cheers
Thorsten

PS 2 game cheats's picture

Extensions

On October 15th, 2007 PS 2 game cheats (not verified) says:

I've found the some of the OpenOffice Extensions for Firefox useful.

Home Refurbish Course's picture

We think this is an

On September 30th, 2007 Home Refurbish Course (not verified) says:

We think this is an inspiring article.

My XXX Ladies's picture

I choose my very sexy lades

On September 28th, 2007 My XXX Ladies (not verified) says:

I choose my very sexy lades and make sure their the best, just like this article.

new thumbs daily's picture

A really good article.

On September 18th, 2007 new thumbs daily (not verified) says:

A really good article.

Greece Travel's picture

openoffice

On October 11th, 2007 Greece Travel (not verified) says:

Thanks for sharing that article.
I have been using OpenOffice for several years now and am very impressed with it. Going to have a closer look at the various extensions available for it.

Anonymous's picture

Extension lists

On February 17th, 2007 Anonymous (not verified) says:

You can find OpenOffice.org extensions list here:

* with Italian language comments:
http://linguistico.sf.net/wiki/doku.php?id=openoffice.org#estensioni

* with English language comments:
http://wiki.services.openoffice.org/wiki/Extensions_repository

Travel Bookings's picture

Open Office

On October 23rd, 2007 Travel Bookings (not verified) says:

Thanks for sharing that information about the Open Office extensions. I have been using OO for a few years now, and it has been an excellent tool for me. Any new add-ons or extensions would definately be most welcome.

Anonymous's picture

Mediawiki extention

On September 21st, 2006 Anonymous (not verified) says:

Maybe i'll see my long time desired Mediawiki import/export extention

Anonymous's picture

[OT] Openoffice fileformat code reuse

On August 1st, 2006 Anonymous (not verified) says:

For some time i've been wondering if the incorporation of openoffice fileformat related code would be legal in say, a document viewer.

Anyone willing to comment ?

Post new comment

Please note that comments may not appear immediately, so there is no need to repost your comment.
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <pre> <ul> <ol> <li> <dl> <dt> <dd> <i> <b>
  • Lines and paragraphs break automatically.

More information about formatting options

Newsletter

Each week Linux Journal editors will tell you what's hot in the world of Linux. You will receive late breaking news, technical tips and tricks, and links to in-depth stories featured on www.linuxjournal.com.
Sign up for our Email Newsletter

Tech Tip Videos

From the Magazine

July 2009, #183

News Flash: Linux Kernel 3.0 to include an on-the-go Expresso machine interface! Ok, maybe not, but Linux is definitely going mobile, from phones to e-readers. Find out more inside about Android, the Kindle 2, the Western Digital MyBook II, The Bug, and Indamixx (a portable recording studio). And if you've gone mobile and you been wanting more Emacs in your life then check out Conkeror.


To compliment the mobile we've got the stationary: parsing command line options with getopt, checking your Ruby code with metric_fu, and building a secure Squid proxy. How is this stationary you ask? What can we say? It's not. We just wanted to see if anybody actually read this part of the page :) .


All this and more, and all you have to do is get your hot sweaty hands on the latest copy of Linux Journal.





Read this issue