- of

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.
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,
- of

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













Chrome for Android Mobile Browser Proves Speedy, Slick
Motorola Droid 4 Offers Killer QWERTY Slider Keyboard
iPad 3: 10 Design Ideas Apple Should Borrow
10 Hot Tech Products Sure to Fire Up the Market in 2012
iOS, Android App Economy Fuel 500K U.S. Jobs: TechNet
Microsoft's Windows 8 Minimized Ribbon, Sensors Among New Feature[..]
View All Slideshows >















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.Recent Slideshows
View Slideshow >
View Slideshow >
View Slideshow >
View Slideshow >
View Slideshow >
View Slideshow >