12 Comments

Summary:

VMware was not the only pre-release surprise this past week as OpenOffice.org launched a beta of their new 3.0 office productivity suite complete with native OS X GUI support (no need to run X11 anymore!) along with a sizable list of other enhancements and bug fixes. […]

VMware was not the only pre-release surprise this past week as OpenOffice.org launched a beta of their new 3.0 office productivity suite complete with native OS X GUI support (no need to run X11 anymore!) along with a sizable list of other enhancements and bug fixes. TAB put the suite through a series of tests to help readers determine if this 168MB download is worthy of a spot in their Applications folders.

Welcome To Aqua

The first noticeable item is how quickly OpenOffice 3.0 beta loads, even when compared with Microsoft Office 2008. In less than five seconds you are at the welcome screen ready to create your next masterpiece. Where the X11 interface felt choppy and looked…like an X11 interface, OO 3.0 definitely looks and feels like a fully integrated Aqua application, with menus being very responsive and keyboard shortcuts working (mostly – hey, it’s beta) as expected. How does each behave in this newly integrated world? Let’s take a look.

Writer

Whether it be your latest manuscript, research paper or basic flyer Writer definitely has the tools you need to get the job done. Complex header/footer arrangements, full table of contents manipulation, floating frames and more make this a very sophisticated word & document processor.

I do a great deal of legal document markup and the new notes feature keeps OO 3.0 on track with Pages and Word:

I also especially liked the font preview option for the font menu:

The multi-page layout view mode makes it very easy to see if the visual flow of your document is to your liking:

And, it was refreshing to see a “preview” mode that wasn’t just a export-view to Preview.app:

However, this is also where my first beta bug reared its ugly head with a half-dup of the menubar:

Writer also has basic support for VBA macros, something which neither Pages nor Word 2008 can claim and a feature which came in extremely handy this past weekend for a document I absolutely needed to work with (I could have VMware’d or Boot Camp’d into XP, but OO 3.0 made it so I didn’t have to). That same document also had many form-fields which all worked flawlessly in Writer.

When saving my document, doing so in Microsoft Office compatibility mode produced documents that worked flawlessly on Word 2008 and Word 2003/2007 (on Windows). Importing Microsoft’s new XML-format documents also worked well, though mine aren’t complex by any stretch of the imagination.

Writer is a fine tool, but there are still multi-platform quirks, like the button rendering in some dialogs:

and a less-than Mac-like preferences system:

Calc

I’ll state up-front that I hate spreadsheets. I hate them mostly due to the fact that people use spreadsheet programs as page-layout tools rather then as number crunchers. Numbers understood this and makes no attempt to hide that it is first-and-foremost a way to make pretty, numerical pages. But, getting back to the topic at hand…

Calc is a clear mimic of Excel 2003 for Windows, complete with charting and “solving” capabilities (which the developers are quick to point out do not exist in Excel 2008). Not being a non-work spreadsheet geek (and, I can’t use work examples) I Googled for filetype:xls and pulled a pseudo-random document to work with (the one pictured above). You can see what that Excel document looks like in Excel 2008 just for comparison:

The formatting is pretty much identical and, as a result, I decided to extend my test by checking out Calc’s new charting capabilities:

and then saving in compatibility mode and re-opening in Excel 2008:

I was truly impressed by just how well the two programs worked together, making me a bit more confident if I ever have to use OO 3.0 to edit/share docs with others. I did not have an opportunity to test the new collaboration (i.e. track/merge) feature.

Impress & Draw

With Keynote I have little need for alternate presentation software, but Impress worked as well as previous versions and I did create and preview a quick presentation with no issues:

Similarly, while I have no real need for Draw, it was trivial to create basic line-art documents with this tool:

Database

While it may not have a catchy name like FileMaker (although one could argue that is equally as utilitarian a name) or Bento (I promised myself I would not take this review as an opportunity to trash Bento), OO 3.0′s “Database” application fills a void that exists in Microsoft Office on the Mac and that has been missing in general from the open source world.

The built-in field sets and templates in Database made it trivial to setup a quick recipe database with entry form. And, best of all, I just used the defaults. If I wanted to make it more attractive, I could have spent as much time as necessary crafting primary keys, adjusting field sizes, adding font labels and customizing each feature of the forms. It may be worth it just to keep OpenOffice.org 3.0 around just for the Database program.

The true power of Database comes with full integration into the OO 3.0 suite. I can use the recipe database (if I populate it) to have Writer make a nice recipe file (Database reports could do this as well). Database also allows for data export as well, so you are definitely not locked into the program.

Odds & Ends

Some features spread across the individual components and others were just noteworthy or interesting. For example, when comparing the PDF export feature in Calc, it wound up creating a smaller file than the OS X “print to PDF” option and created table of contents labels based on the spreadsheet tab names.

OO 3.0 also provides a decent number of templates to choose from when starting a new document, some of which aren’t obvious from the flashy “welcome” dialog or just casual interaction with the program (like the full XML document editor).

The help system is very robust and can assist you in pinpointing where to find the functionality you just know is there (like how to mimic Word’s “different first page” feature).

OO 3.0 provides no AppleScript dictionary, so scripters are once again relegated to GUI scripting and the UI – while integrated well with Aqua and with decent Universal Access support – is definitely showing its age. The beta outright crashed on me several times as well, but it confirmed the rock solid document recovery capabilities of the program.

I can say, honestly, that the final version of the software will take its rightful place in my Applications folder, if only to have the ability to deal with the occasional VBA-based document that comes my way and to make use of the Database program.

If you’ve tried OO 3.0 beta or are one of the developers for it, drop a note in the comments with your take on the software and any tips or advice on using the various components. Remember to submit bug reports if you do test the beta and find some quirks. You can also grab a slew of test cases which will cover more of the functionality than I have in this post.

  1. You wouldn’t like me then. I use spreadsheets to create business forms, and they look damn good!

    Share
  2. Thanks for the thorough review, which has me excited that I might finally be able to finally knockout Office from my system. While I love most features of Pages ’08, it is still a .doc world. Pages does a good job of exporting to .doc, but it’s not flawless. So I’ve needed Word for final cleanup. If OpenOffice makes a near perfect export, that changes everything. The same goes for Calc. I like Numbers, but it’s definitely 1.0 software. If Calc has what Numbers doesn’t, then I’m covered there. Keynote is untouchable, so no worries there.

    What’s most exciting is that I may finally be able to wean my staff off Word. They are unhappy with Word, but reluctant to embrace Pages (having to zip archive every email attachment, if you don’t use Mail, doesn’t exactly inspire). Adopting OpenOffice will be an easier sell. Which makes me think…I can create our reporting templates in the far better page layout application Pages and have them use the .doc export in OpenOffice. Hmmm.

    Share
  3. What I’d be interested in hearing is your impressions of Open Office 3.0 compared to NeoOffice, since these two branches of the same basic program are now in competition with each other.

    I’ve tested the two together, and noticed that OOO was a little quicker on the opening, but NeoOffice seemed to consume less RAM. Also, I can switch between documents with the option-tilde in NeoOffice, and I can’t do that in OpenOffice, which is a little annoying.

    Share
  4. [...] to beat. While Neo Office was forked from Open Office quite some time ago, they are still only in beta support for OS X, so it’s best to remain with Neo Office for quite some time [...]

    Share
  5. You must be kidding? Rocks Aqua? :P You guys should wait until version 4 is released. That one will respect the Apple Interface Guidelines.

    This one sucks (in terms of looks). I mean yes, it’s progress and I appreciate that. It’s great. But as a Mac user who likes to see real Mac apps, this just looks like a bad port.

    I can’t wait for version 4 :)

    I do wish to congratulate them on porting all the code to something Mac OS native.

    Share
  6. I’m curious how it compares to NeoOffice too. I get a weekly excel sheet that doesn’t import into NeoOffice and I’d heard it was a bug in the openoffice software. It works in Numbers, but Numbers doesn’t import all the shading. It’d be nice to find one application that will import Microsoft Office files without changing formatting or anything else. THAT would be an application worth having.

    It’s hard to write a resume or paper on pages or NeoOffice and wonder if it’s going to look screwed up for the person who opens it with Word on a pc.

    Share
  7. [...] One: Reviewed on The Apple Blog: “The first noticeable item is how quickly OpenOffice 3.0 beta loads, even when compared with [...]

    Share
  8. What a find — a recipe application. I have an old recipe/cookbook app that I did in VB6 sometime ago. We are thinking about re-doing in in Java so it is easily cross-platform (not that Java is the only way to do this), or use OOv3. I could use some insight as I have not had the time to experiment with OOv3.
    1. Did you need to do a relational design to list all of the ingredients? Normally the recipe would have a file number to be used as an idex for the ingredients as well as any other lists.
    2. If a relational database was not used, how would one do something like this:
    Amount Item Note
    1 Cup Apples, tart Peeled, cored, cut to 1/2-inch pcs.
    1 Cup rhubarb, fresh sliced 1/2-inch pcs.

    Thanks,
    Dave

    Share
  9. If you want individual launchers for the different parts of OpenOffice.org, I created some you can download here:

    http://stuporglue.org/openoffice.org-aqua-launchers.php

    These are separate launchers for Calc, Write, Impress, etc.

    There is another download on the same page for command line launchers like on Linux (oocalc, oowrite, etc.)

    Share
  10. Have they managed to *finally* keep absolute references is a formula from being broken? If a cell contains the formula ‘=$A$1+C1+D1′ and I click on the formula and drag the $a$1 reference with my mouse to, say, B1, the formula now reads ‘=$B$1:B1+c1+d1′ instead of ‘=$B$1+C1+D1′ as it should be. Has this been fixed in 3.0?

    Share

Comments have been disabled for this post