OpenOffice.org 3.0 review

Whether OpenOffice 3.0 is right for you comes down to this decision: can you live without the latest features in Microsoft Office 2007?

OpenOffice.org is a powerful productivity suite - including tools for word processing, spreadsheets, slideshows and more - with one major additional feature: it's free. It works for Windows, Mac and Linux systems.


Most of the tools you need for productivity are included in OpenOffice.org 3.0, minus an email client. There's Writer, a powerful word processor; Calc for spreadsheets; Impress for slideshows; Draw for basic drawing and graphics; and Base to serve as - you guessed it - a database.

OpenOffice.org 3.0: major improvements

OpenOffice.org 3.0 OpenOffice 3 is a major upgrade over the previous version, with plenty of new features, native OS support, and all the tools most people would need to get their work done. You begin in a splash screen called the Start Center, with new icons for the different applications you can select (you can't start the individual apps from the Applications folder). You can share data between apps, and run more than one module at the same time.

OpenOffice 3.0 is fast. The Writer application zips along, formatting a 200-page novel at lightning speed - like we were using a basic txt editor.

Calc, the spreadsheet program, also runs fast. OpenOffice.org - which is a collaborative effort from developers who donate their time - does not post the minimum processing speed to run the apps, and says that only 256MB RAM is required. However, we'd recommend you have at least a gig of RAM.

There's another major change in the latest version of the software: OpenOffice.org 3.0 supports the OpenDocument 2.1 (ODF) standard, a popular format that's used around the world, especially by government agencies. Speaking of format support: Writer supports Microsoft Word files, so you can open them and then save them in Word format or as ODF.

However, if you want to save a document in Word format, you must continually choose "Save as" because the program does not natively support Word. In fact, the Save menu is dimmed when you open a Word file. This forces you to make a decision about whether you should start using ODF, a format that is still not supported by Microsoft Word.

OpenOffice.org 3.0: each program updated

So what has changed in each app? For starters, Writer now supports editing notes that run along the side of the screen - something like Word's comment bubbles. These can be formatted with a different color for each editor, which facilitates group editing of documents; but it's a far cry from the extensive comment bubbles, markup, and reviewing pane options in Word 2008, which allow you to track all changes, see the original document and various other views, and highlight changes.

Writer has a new zoom slider on the status bar and a way to view multiple pages on the screen at once. If you're a former Office user switching to OpenOffice.org 3.0, you may be annoyed to find that you can't hover your mouse over the status bar to see what the features will do - and there's no pop-up help system. However, there is extensive documentation and loyal users willing to provide forum support, however.

Calc now includes a Solver wizard that helps you optimise the calculations within cells on a spreadsheet. It works okay, but it's no deal-closer - no one buys a spreadsheet program for a calculation solver. OpenOffice.org 3.0 enhances the chart functionality in Calc, supporting regression equations and correlation coefficients. Most importantly, a pie chart we made in Calc - from a home budget spreadsheet, which includes 24 workbooks, thousands of calculations, and extensive data sets - rendered quickly.

We also like the new workbook-sharing feature: you can click an option to share your data, a co-worker can make changes, and then you can integrate those changes back into the original document. This feature, which is available in Excel, was sorely lacking in previous versions of OpenOffice. Calc also supports up to 1,024 columns in a spreadsheet as opposed to only 256 in the previous version.

Impress, the slideshow program, can now perform a few extra tricks. You can import a table from Calc and edit it directly - it's no longer just a static image. Our favourite addition, though, is multi-monitor support.

Draw has only a few enhancements, including a way to crop images by just grabbing handles and moving them.

Unfortunately, even with these new features, there's still a lot missing compared to Office 2007. Most critical: the latest Microsoft suite uses elements for documents, charts, tables, and other sections of your document that allow you to quickly format your pages. They are amazingly helpful - a bit like templates, but for individual sections of your document.

When using OpenOffice.org 3.0, we also really missed Microsoft Office's snazzy notebook view, noteflags, annotated audio clips you can export to an iPod, multi-page printing, enhanced auto correction features, and advanced document security. OpenOffice.org also doesn't provide any email or calendaring apps, which is not a major gripe - there are plenty of open source options available.

System requirements

Windows 2000 (Service Pack 2 or higher)/XP/Server 2003/Vista; 256MB RAM (512MB RAM recommended); 650 MB available disk space for a default install (including a JRE) via download, after installation and deletion of temporary installation files, OpenOffice.org will use approximately 440MB disk space; 1024x768 or higher resolution with at least 256 colours. Mac OS X 10.4 (Tiger) or higher; Intel Processor; 512 MB RAM; 400 MB available disk space; 1024 x 768 or higher resolution with 16.7 Million colours

Verdict

The decision here is not whether OpenOffice.org 3 is worth the download--the program is free - but whether you really need to buy Microsoft Office 2007. Ultimately, Office 2007 is the superior product. You'll get extensive call-in support, few crashes, and the latest and most advanced features. On the other hand, OpenOffice.org 3.0 is one of those 80-20 products. It will do what 80 percent of what most of people need it to do. It's speedy, feature-rich, and does what it says it will do very well. And if that's all you really need (and if you can live without the latest Office features), it's definitely worth the effort.