Linux, Open Source & Ubuntu - eWeek

Linux, Open Source & Ubuntu: OpenOffice.org 3.2 Racks Up Spreadsheet Tweaks and File Format Fixes

By Jason Brooks on 2010-02-24


The latest version of the OpenOffice.org productivity suite, 3.2, has grown better at handling Microsoft Office's XML-based file formats, and demonstrates slow, but promising new developments on the feature add-on front. Check out the slide gallery below for a look at the suite in action, and be sure to read eWEEK Labs' full review,

OpenOffice.org 3.2 Racks Up Spreadsheet Tweaks and File Format FixesBy Jason Brooks

OLE Object Support, After

OpenOffice.org 3.2 comes with better support for documents saved in Microsoft's OOXML format, including support for Pivot Tables and OLE objects embedded in Excel spreadsheets.

OLE Object Support, Before

In OpenOffice.org Version 3.1 the sorts of embedded objects that Version 3.2 displays without issue end up lost in translation.

Password Protection in 3.2

Version 3.2 of OpenOffice.org adds support for opening password-protected documents stored in Office 2007's default format.

Password Protection in 3.1

In the previous OpenOffice.org release, opening password-protected OOXML documents turned up this dead-end import dialog.

One-Way Password Protection

More work remains on the OOXML password-protected document support front, however, as OpenOffice.org 3.2 can't modify these documents and send them back in that newer format.

Two-Way Password Protection

However, OpenOffice.org does a fine job creating and modifying password-protected Office documents using the older binary formats.

MediaWiki Extension

The MediaWiki export feature of OpenOffice.org Writer has moved out into an extension in Version 3.2.

MySQL Connector Extension

I was impressed with the project's MySQL Connector extension, which makes it easy to access this database from applications across the suite.

MySQL in Calc

Once I'd established the connection to my MySQL database with the connector, I could access my tables and queries throughout the suite.

Query Wizard

I could create queries for my MySQL database within OpenOffice.org Base using the application's query wizard, or by inputting my own SQL.

Copy and Paste of Noncontiguous Ranges

I was happy to see that OpenOffice.org's Calc spreadsheet application now supports copying and pasting noncontiguous ranges of cells.

Fun with Auto-complete

Calc sports a smarter auto-complete feature that correctly recognizes new patterns such as IP address ranges.

  • More slideshows

Advertisement

FEATURED SPONSOR MESSAGE

Start the New Year with business intelligence—it’s a smart move

Join us on February 1 for an encore rebroadcast at either 5 am or 12 noon EST and discover how business intelligence (BI) supports companies in uncertain business and economic climates. Get expert advice on how to create a strategy that fits your organization's needs and budget and see how quickly it can pay for itself.

Click Here

Brought to you by

 

eWEEK Quick LInks