3 recent OpenOffice.org extensions

Although I do most of my professional writing in Bluefish, I usually use OpenOffice.org at least once a day. Consequently, I keep a close eye on the OpenOffice.org Extensions page.

These days, many extensions are language-specific or clipart collections that most people will never use. Others are filters for exchanging files with specific formats, such as Google Doc. Annoyingly, some recent extensions are thinly disguised advertisements for a company's service or issued under proprietary licences, although OpenOffice.org seems less plagued by these problems than Firefox.

Still, useful workaday extensions keep being posted. Here are three of the ones I've been test-driving recently: History Master, VisibleBookmarks, and Writer's Tools. All of them are installed in the usual way, by downloading them to your system, adding them through Tools -> Extension Manager, then restarting OpenOffice.org, although Writer's Tools does require some additional setup.

History Master

By default, OpenOffice.org lists the last ten documents you have opened in the sub-menu File -> Recent Documents. This arrangement is fine, so far as it goes, and an improvement over the distant days when only three recent documents were displayed. But History Master goes further, adding all the enhancements that people regularly ask for on the mailing lists and then some.

History Master adds two items to the menus. The first is File -> Recent documents of the same type. This item opens the History Master Window to allow you to filter the list so it only shows documents of one type -- for example, word processing documents, or spreadsheets. When you have a long list of recent documents, this list can greatly simplify locating a document.

The second menu addition is Tools -> Add-Ons -> History Master - List handling, which opens the extension's main window. From here, you can do such frequently requested actions such as set the length of your recent document list from 0-100, and either clear or selectively delete the list. You can also move items up or down in the list (which can be handy if you want to keep a frequently used item on the list) or remove any documents from the list that are no longer accessible because they have been moved or deleted. In addition, you can switch between the default picklist and URLS if you are working with HTML documents.

None of these features are particularly arcane, but History Master also adds an entry into OpenOffice.org's Help, something that you might wish more extensions did. In fact, History master is so simple, so useful, and so careful to making menu changes where appropriate, you might wish that more extensions would follow its lead in general.


OpenOffice.org is not ideal for HTML because it does not produce clean code, and, if you use it with styles the way you are supposed to, you can use headings and the Navigator to find your way around a document. However, there are still times when you might want to use bookmarks. The only trouble is, although bookmarks are listed in the Navigator and are highlighted when you jump to them, most of the time, they look no different than the surrounding text.

VisibleBookmarks remedies this situation. It installs a three item sub-menu to Tools -> Add-ons, and, three icons on the left of the Standard toolbar -- a position that, annoyingly gives it more prominence than basic functions such as New or Open (although you can move them).

What VisibleBookmarks does is take advantage of OpenOffice.org's recently added notes pane. When you select the Visible Bookmarks icon, the extension opens a notification window telling you how many bookmarks it found, and adds a note giving the bookmark's name and anchor text. You can, of course, add other information to the note if you choose. Select Remove inserted notes, and the bookmark notes are deleted.

VisibleBookmarks also has an option to make the bookmark-related notes visible even when View -> Notes is not selected. Unfortunately, though, this option does not work if my experience is any indication. However, since View -> Notes is selected by default, that is a small flaw.

My personal preference would be to add a shading for bookmarks in Tools -> Options -> OpenOffice.org -> Appearances. But, short of that, VisibleBookmarks seems an acceptable alternative.

Writer's Tools

Written by my fellow journalist Dimitri Popov, Writer's Tools is an extension that frequently finds its way to the top of the list of the most popular offerings at OpenOffice.org Extensions. I reviewed Writer's Tools in one of its earliest incarnations, but it has changed extensively in the eighteen months since then.

Writer's Tools is considerably more complex than the average extension, and some of its features require setting up a database. You might want to consider buying and downloading Popov's documentation to go along with the extension, although you can find instructions for free online if you do a little searching.

The extension installs a separate top-level menu, with a list of twenty features. My main complaint about the extension is that this menu could be be better organized, with similar features grouped together and separated from other categories by separators, but, this inconvenience is relatively minor.

Among Writer's Tools features are a number of extensions to online resources, such as Google Translate and Maps. Other tools back up or your work to email or a remote site, including Amazon S3, or post it to a blog. For actual productivity, Writer's Tools offers a timer and visual word count, a notebook, and a task list, and several features for managing bookmarks. Despite the name of the extension, many of these tools would be useful for any one using OpenOffice.org.

None of Writer's Tools features are standouts. However, taken as a collection, they add up to a solid set of tools -- and ones that, unlike the features in other applications for writers, you might actually want to use, regardless of whether they consider themselves a writer or simply a word processor user.

Something for everyone

These extensions will probably not fit everybody's needs or habits. Still, they are worth trying, and so are many of the other extensions that are released each week.

Although they can vary wildly in quality, OpenOffice.org's extensions are the closest that the project has come to truly community-oriented development. Explore the site, and if what you download doesn't suit you -- well, the price was right, and all you've lost is a few minutes of your time.


Bruce Byfield (nanday)


Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Would use if but

Anonymous's picture

I would love to switch to OOo at work. Unfortunately, there are two things which keep me from switching:

1. I need the ability to merge text into "frames" and tables. When I try to merge from my application, I get this error: "com.sun.star.task.ErrorCodeIOException."

2. I need the ability to define a specified size "frame" in Writer into which I can merge an image and have the image, not the frame resize itself so that it fills the frame and retains its proportions. What happens instead is if I try to merge into an image frame is I get this error: "Variant does not reference an automation object."


Jason's picture

Apexwm, Like you I am surprised many companies refuse to use open office as a platform. However many hours (man-years) go into the programming, testing and other vetting procedures with every release. I do not mean to be directly and overly objectionable but I feel like any open source project worth it's salt deserves at least a donation. Certainly a stable and mature package like open office. Just taking the opportunity to encourage people to give back a little bit to those that give their lives to the development of usable technology, not trying to incite.


preposterous's picture

Ok, I am confused, you writing professionally in Bluefish, is that not a http editor? Are you a Writer or Programmer? Or is there another program called Bluefish?

I would love to...

Davis's picture

Not only does my employer NOT use Open Office, it has banned its existence from our computers. Any transgressions will result in a censure from HR. Nice, real nice. "Is this good for the company?"

Open Office BASE

Gary Smyth's picture

My only wish for Open Office is that BASE be compatible with Microsoft Office 2007 Access database files.

My college uses the dreaded OS which shall not be named here, and when I downloaded an Access database to my Linux OS, Open Office did not recognize the .accdb extension.

I'd like BASE to be able to read and write the .accdb format in Access 2007 or even 2010.

Great product

apexwm's picture

I'm surprised more companies don't migrate to OpenOffice, from Microsoft Office. It's a great product, and does a pretty good job at importing many other formats. It's extensibility is amazing, but is because it's open source. The power of open source makes it a great product. With Microsoft Office, users are restricted both with licensing but with addons and usually the addons cost extra on top of the Office software itself. With OpenOffice, you can always count on being able to find addons/extensions for free.

Geek Guide
The DevOps Toolbox

Tools and Technologies for Scale and Reliability
by Linux Journal Editor Bill Childers

Get your free copy today

Sponsored by IBM

Upcoming Webinar
8 Signs You're Beyond Cron

Scheduling Crontabs With an Enterprise Scheduler
11am CDT, April 29th
Moderated by Linux Journal Contributor Mike Diehl

Sign up now

Sponsored by Skybot