OpenOffice.org Grows Up
Nine years after Sun Microsystems bought StarOffice, the resulting OpenOffice.org project is ready to roll out its 3.0 release. Enhanced format compatibility and features put it on par with Microsoft Office.
The marketing materials at the OpenOffice.org project site describe the PDF import option as a resort for making small changes to PDFs for which the editable originals have gone missing; in other words, users should keep their expectations for this feature fairly modest.
Indeed, after spending a bit of time testing the suite’s new PDF import function, I’d be hard pressed to imagine many circumstances in which I’d find the feature useful. Imported PDF documents open within the suite’s presentation application, Impress, and text is editable on a line-by-line basis.
I was able to import a PDF I had created using OpenOffice.org with fairly good fidelity, but when I opened one of eWeek’s production PDFs created in Adobe InDesign, the result was too mangled to be exported again into PDF form and pressed back into service.
Calc Spreadsheet
In addition to the formula compatibility enhancements made possible by the new ODF 1.2 format, OpenOffice.org 3’s spreadsheet application, Calc, packs a handful of useful new features aimed at bringing the application more closely in line with Microsoft Excel’s feature set.
One such new feature is the Solver, a tool for analysing multivariable solutions that’s been available for a while in Excel as a standard add-in. I located a sample spreadsheet configured for use with Excel’s solver, and analysed the data using both Excel 2007 and OpenOffice.org 3. With the exception of a difference in the way the two applications defined non-contiguous fields in their respective solver tools (Excel used commas between field labels, and allowed me to control-click on non-contiguous variable cells, while Calc used semicolons and made me type them in), both solver tools performed the same.
The version of OpenOffice.org 2.4 that ships with Ubuntu and other Linux distributions already includes a solver tool, but licensing issues have kept it out of Sun’s official OpenOffice.org build. I tried the same test with this earlier solver version and couldn’t get the tool to work with non-contiguous cells.
Also on the feature parity and file compatibility front, the version of Calc that comes with OpenOffice.org 3.0 now supports custom error bars in charts, and a boost in the number of columns a sheet can hold from 256 to 1,024. To compare, Microsoft raised its column limit in Excel 2007 from 256 to 16,384.
Calc also now includes a spreadsheet collaboration feature that enables multiple users to work together on spreadsheet documents.
Other Applications
Beyond its PDF import functionality, OpenOffice.org 3’s presentation application, Impress, includes a couple of promising new enhancements, chief of which is support for embedded tables in Impress documents. Previously, the only way to embed tables in Impress was to paste in a spreadsheet object from Calc.
Impress also sports a polished picture-cropping tool, which abides by the typical, corner-dragging interface metaphor that you would expect to see in an image-editing application.
The OpenOffice.org 3 word processor application, Writer, now comes with a much-improved document-annotation feature, which places inserted notes in the margin of a document, with a line that traces back to the annotated portion of your document. What’s more, notes from different editors appear in different colors.
In previous versions of OpenOffice.org, inserted notes appeared as tiny yellow boxes in the document that you had to click on to read. As implemented, the feature was practically worthless, and it complicated collaborative editing with those taking advantage of Word’s much-better-implemented notes feature.
