Preston Gralla's picture
Preston Gralla

Seeing Through Windows

Review of final OpenOffice 3: Why buy Microsoft Office?

The final version of OpenOffice 3 is out today, and if you're looking to save yourself plenty of money, download it instead of buying Microsoft Office --- you could save yourself hundreds of dollars, and not lose out on many features.

I put the Windows version through its paces, and am about to download the Linux version as well. The suite has six full-blown applications: the Writer word processor, Calc spreadsheet, Impress presentations program, Base database program, Math equation editor, and Draw graphics program.

Given that the full suite is free, this is one of the best deals you'll find in all of computing. It'll do just about anything you expect from an office suite, whether creating documents, spreadsheets, or presentations. You'll find solid formatting tools, as well as extras including mail merge, macros, charting capabilities, and more.

OpenOffice works with an extremely wide variety of formats, including the OpenDocument Format (ODF) 1.2 standard, as well as documents created in Microsoft Office 2007 and Office 2008 for the Mac. You can even export files to PDF.

It won't, however, work with the newest Office 2007 formats such as .docx. At the moment, that's not a significant drawback, because those formats are rarely used. However, in the future this could cause some problems, so I'm hoping Office 2007 formats will soon be handled as well.

One of the suite's most useful features are its wizards, which walk you through creating spreadsheets, presentations, and other documents, as you can see below. They pay a great deal of attention to the task at hand. For example, you're asked for the output medium of a presentation before you begin.

Most people will most likely spend most of their time in Writer, creating word-processing documents. It has all the features you'd expect, but some very nice extras as well. With a single click, for example, you can bring up a gallery of backgrounds, bullets, and other graphical elements, and then embed them in your document, as you can see below. You can even embed sounds.

Writer is also useful for creating HTML documents, and includes tools for creating hyperlinks, as you can see below, and even includes the ability to create targets.

Is the suite perfect? Of course not. The overall interface is just plain dull, and is not nearly as useful as the Microsoft Office 2007 ribbon. It also doesn't have the high-end features of Office 2007, such as QuickParts. You also won't find many templates.

Still, if you're looking for a suite to use at home or a small business -- or if your enteprise hasn't standardized on Office -- you should give this suite a try. It'll save you hundreds of dollars. And in today's economic times, that's a very big deal.

Like this blog? Subscribe to the RSS feed!

What People Are Saying

Hey I have installed Open

Hey I have installed Open Office 3 on Linux Ubuntu 10.04 and I have experienced a strange problem. The write program headers are all in a foriegn language, I suspect Hebrew, but the program writes in English, and even the settings are set to english, but appear in the foreign language. I know this isn't really the place to ask, but I have tried all of the Open Office sites and can find nothing to help me. Thanks

Nobody uses docx?

WRONG! Most people install or get Office 2007 and don't change the default settings, one of which is to save all Word documents to the docx format. So, the rest of us suffer while trying to eddycate those people about why Bill Gates is not their friend, and yes, they might need to change their settings if they want to keep their friends.

In 2010, still only few

Still, in 2010, many (most?) still don't even use Office 2007. With the hurting economy, nobody's upgrading PCs or software. The previous versions work just fine. Most small, medium and even large size organizations aren't about to spend many thousands of dollars just to upgrade to Office 07 (or Office 10) any time soon. So, here's what actually happens. The typical 07 user doesn't change the default settings. The first five or six emails they send with .DOCX attachments result in five or six angry replies. They resave and resend the documents as .DOC. Word automatically remembers the settings. They use .DOC from then on and don't notice the difference. Occasionally, the sophisticated but misguided sender insists that the recipient should download a viewer. By saving three seconds, one time, he or she wastes tens of minutes, many times for many people, alienating both colleagues and, most importantly, customers.

Your comments is dated in

Your comments is dated in 2010: openoffice org supports Office 2007 now. This review is from 2008.

Actually, no, OOo doesn't

Actually, no, OOo doesn't support *output* to .docx, at least as of Aug 20, 2010. That's a big problem.

OpenOffice isn't MS Office

OpenOffice isn't MS Office and thus doesn't support MS Office files 100%, yes you'll continue to see things aren't formatted quite the same but it shouldn't take long to reformat them.

"OpenOffice isn't MS Office

"OpenOffice isn't MS Office and thus doesn't support MS Office files 100%, yes you'll continue to see things aren't formatted quite the same but it shouldn't take long to reformat them."

it shouldn't take long to reformat them? It tooks forever! To make a good ppt takes 2 to 4 times more in Open Office than MS Office.

The ribbon is much better

The ribbon is much better than a multitude of menus and toolbars. Instead of claiming it to be a mess, try actually using it and you'll see it's much more inuitive than menus and toolbars. These are fine for apps with a few options but Office has hundreds of commands.

You need to install Service Pack 2 for MS Office 2007 to be able to open OpenOffice file, prior versions of MS Office cannot open them and you'll need to "save as" MS Office 97-2003 files in Writer/Calc/Impress. I'd recommend setting Writer, Calc and Impress to default to these when clicking "Save As".

Question about OO Formatting

We have begun installing Open Office on our work computers. When I opened a MS Word document on one of those machines last week, the margins were wrong. Page one had jumped down onto page two. My question is this: will this automatic formatting be a continual problem, or is there a way to set OO to just open (and keep) all Word documents in their original/intended formatting? (I'm not terribly tech savy so I hope this makes sense.)

can't download openoffice

I was downloading openoffice when it stuck with 14minutes and 20 seconds to go. Then the box came up "unable to download." I have Windows 7 and it is completely incompatible with Word Perfect 11. What should I do?