Review of Office Suite for Macs

OpenOffice 3.0.1: A New Mac-Based Interface screen
Courtesy of is a free office suite that provides all of the core tools a business or home office user needs to be productive in a day-to-day work environment. includes five core applications: Writer, for creating text documents; Calc, for spreadsheets; Impress, for presentations; Draw, for creating graphics; and Base, a database application. is Open Source software, and is available for many computing platforms. We will review OpenOffice 3.0.1 for the Macintosh.

OS X Aqua Interface Comes to

It’s about time. For years, used the X11 windowing system to create and run its graphical user interface. X11 may have been a good choice when’s primary role was to provide office applications in Unix/Linux OSes, where X11 was a common windowing system. It also allowed the developers to more easily run the application on multiple computer systems; essentially any computer that could run an X11 windowing system could run This included Unix, Linux, Windows, and Mac, as well as others.

But the down side to X11 is that it is not the native windowing system for most platforms. That means that users not only had to install X11, they also had to learn a new user interface that was markedly different than the native windowing system on their computers. To put it bluntly, the older versions of that required the X11 windowing system would have earned a big fat one star rating from me. The applications worked well, but it makes no sense to force individuals to relearn basic window and mousing styles just to use an application.

X11 was also slow. Menus took time to appear, and because you were operating in a different windowing system, some of the keyboard shortcuts that make an application easer to use wouldn’t work.

Thankfully, replaced X11 with a native OS X Aqua interface that ensures that not only does now look like a Mac application, it works like one as well. Menus are now snappy, all keyboard shortcuts work, and the applications simply look much better than they did before.

Writer:’s Word Processor

Writer is the word processor application included with Writer can easily become your primary word processor. It includes powerful capabilities that simplify day-in and day-out use. The AutoComplete, AutoCorrect, and AutoStyles features let you concentrate on your writing while Writer corrects common typing errors; completes phrases, quotes or words; or senses what you’re doing and sets your entry as a headline, paragraph, or what have you.

You can also manually create and apply styles to paragraphs, frames, pages, lists, or individual words and characters. Indexes and table can have a defined structure made up of formatting options such as fonts, size, and spacing.

Writer also supports complex tables and graphics that you can use to produce compelling documents. To make it easier to create these documents, Writer can create individual frames that can hold text, graphics, tables, or other content. You can move the frames around your document or anchor them to a specific spot. Each frame can have its own attributes, such as size, border, and spacing. Frames allow you to create simple or complex layouts that move Writer beyond word processing and into the realm of desktop publishing.

Two of the features of Writer that I really like are slider-based magnification and the multi-page layout view. Instead of selecting a set magnification ratio, you can use a slider to change the view in real time. The multi-page layout view is great for longer documents.

Calc:’s Spreadsheet Software’s Calc reminded me almost instantly of Microsoft Excel. Calc supports multiple worksheets, so you can spread out and organize a spreadsheet, something that I tend to try to do. Calc has a Function Wizard that can help you create complex functions; it’s also handy when you can’t remember the name of the function you need. One drawback to Calc’s Function Wizard is that it’s not all that helpful; it assumes you already have a pretty good understanding of a function.

Once you create a spreadsheet, Calc offers most of the tools you’ll find in other popular spreadsheet applications, including Data Pilot, a version of Excel’s Pivot Tables. Calc also has Solver and Goal Seeker, a handy set for tools for finding the optimum value for a variable in a spreadsheet.

Any complex spreadsheet is bound to have a problem or two when you first create it. Calc’s Detective tools can help you find the error of your ways.

One place where Calc doesn’t perform as well as the competition is in charting. Its charts are limited to nine basic types. Excel has umpteen gazillion charting types and options, although you may find the smaller selection in Calc meets your needs and simplifies your life.

Impress:’s Presentation Software

I have to admit I am not a presentation maven, and I don’t use presentation software very often. That being said, I was impressed by how easy it was to use Impress to create slides and a presentation.

I used the Presentation Wizard to quickly create a basic background as well as the slide transition effects I wanted to apply to the entire presentation. After that I was taken to the Slide Layout, where I could choose from a gallery of slide templates. Once I chose a slide template it was an easy matter to add text, graphics, and other elements.

Once you have more than a few slides, you can use the viewing options to display your presentation in different ways. The Normal view shows a single slide, which is good for making changes and creating each slide. The Slide Sorter allows you to rearrange your slides by simply dragging them around. And the Notes view lets you see each slide with any notes you may wish to add about the slide to help in your presentation. Other views include Outline and Handout.

Wendy Russell, the About Guide to Presentations, has a nice set of 'Beginner's Guide to OpenOffice Impress'.  I followed her ‘Getting Started with OpenOffice Impress’ article to create my first presentation.

Overall, I was impressed with how easy it is to use Impress, and the quality of the presentations it creates. By comparison, Microsoft PowerPoint offers a great deal more capabilities, but at the cost of a higher learning curve. If you only occasionally create presentations, or create presentations strictly for in-house use, then Impress may fit your needs nicely.

Draw:’s Graphics Software


Draw is really a companion product to Impress,’s presentation software. You can use Draw to spiff up slides, create flowcharts, and create basic vector-based drawings. You can also use Draw to create 3D objects, such as cubes, spheres, and cylinders. While Draw isn’t up to creating a 3D model of the plans for your next house, you can use it to spice up you presentations with simple graphics touches.

Draw provides the usual vector graphics drawing tools: lines, rectangles, ovals, and curves. It also has an assortment of basic shapes that you can pluck down onto your drawing, including standard flowchart images and callout bubbles.

It’s no surprise that Draw integrates well with Impress. You can easily bring slides into Impress and then send the finished slides back to Impress. You can also use Draw to create new slides from scratch to use in Impress. You can also use Draw for basic drawing needs or for creating flowcharts for work-related projects. It isn’t really a general-purpose drawing tool, but it’s a handy tool for adding sparkle to’s other applications.


Base:’s Database Software


Base is similar to Microsoft Access, database software that is missing from the Mac version of Microsoft Office. Unlike other popular databases for the Mac, such as FileMaker Pro, Base doesn’t hide its internal structures. It requires you to have at least a basic understanding of how a database works.

Bases uses Tables, Views, Forms, Queries, and Reports to work with and create databases. Tables are used to create the structure to hold data. Views allow you to specify which tables, and which fields within a table, will be visible. Queries are ways to filter a database, that is, find specific information about and relationships between data. Queries can be as simple as “show me everyone who placed an order in the past week,” or very complex. Forms allow you to design how your database will look. Forms are a great way to display and enter data in an easy-to-use graphical manner. Reports are a specialized form for displaying the results of queries or the unfiltered data in a table.

You can manually create tables, views, queries, forms, or reports, or you can use Base’s wizards to help you through the process. The wizards are easy to use, and I found that they created just the item I wanted. The Table Wizard is especially helpful, because it includes templates for popular business and personal databases. For instance, you can use the wizard to quickly create a recipe database or an invoicing system for your business.

Base is a powerful database software program that can be difficult for some individuals to use because it requires advanced knowledge of how databases work. Wrap Up


All of the applications included with were able to read all of the file types I threw at them, including recent Microsoft Office Word and Excel files. I didn’t try all of the file types that documents can be saved as, but when saving as .doc for text, .xls for Excel, or .ppt for PowerPoint, I had no problems opening and sharing files with Microsoft Office equivalents.

I did notice a few quirks in use. Some windows and dialog boxes were physically large, with excessive amounts of white space or perhaps more technically correct, gray space. I also found the toolbar icons small, and would have preferred more customization options.

In general, I found Write and Calc to be extremely usable, with most of the features most writers will ever need. As I mentioned earlier, I’m not a user of presentation software, but I found Impress easy to use, although somewhat basic compared to applications like PowerPoint. Draw was my least favorite application. It’s very evident that Draw’s primary purpose is to allow you to create graphics for Impress slides, or to create new slides for a presentation. For its intended purpose it works reasonably well, but it didn’t meet my expectations for a general-purpose drawing tool. Base is a reasonably good database application. It offers plenty of capabilities, but lacks an easy-to-use interface, something I’ve grown used to with other Mac database applications.

As a package, 3.0.1 earned three stars out of five, although on their own, the Writer and Calc applications deserve at least four stars. Specifications


  • Mac OS X 10.4 (Tiger) or better
  • Intel-based Mac
  • 512 MB RAM
  • 400 MB hard drive space
  • Java Runtime Environment (JRE) 1.5 or later (JRE is included with OS X)