Imagine being able to open any Web page on your server in OpenOffice.org, edit it, and save the changes back to the server by pressing the Save button. It may sound too good to be true, but that's exactly what the ODF@WWW project is set to achieve.
While OpenOffice.org Base is good for storing and querying data, it doesn't provide any easy way to chart information. This is exactly what Calc does best, with its dedicated chart module. If you want to visualize data stored in a Base database, you can write an OOo Basic macro that pulls data from a database, inserts it into a Calc spreadsheet, and then creates a chart. Here's how.
Alternative Find and Replace for Writer (AltSearch) has the ambitious goal of replacing and enhancing one of the most basic pieces of OpenOffice.org functionality. It's undermined by a chaotic interface, but if you have the patience to continue past first impressions, you will find AltSearch comes far closer to fulfilling its promise than you might initially imagine.
Easy PDF editing is coming to OpenOffice.org, but you'll have to be patient for a few months. Recently posted to the OpenOffice.org Extensions site, the Sun PDF Import extension (SPI) is only in beta, and only works with recent developer builds of OpenOffice.org 3.0, which is scheduled for September release. Right now, the quality of the final release is anybody's guess, but the beta's capabilities fall squarely in the middle of the available PDF import tools.
Oracle and now IBM seem to have strange ideas about creating a business around open source software for the enterprise. First it was Oracle's Unbreakable Linux program, derived from Red Hat Enterprise Linux sans its proprietary bits and supported for peanuts to beat RHEL and similar community projects such as CentOS. Now it's IBM, which has taken old OpenOffice.org code under the now-retired Sun Industry Standards Source License and released it as a proprietary closed source freeware office suite. The first stable release of IBM Lotus Symphony, released last week, has no obvious advantages over OpenOffice.org. The suite is targeted at enterprise customers, at the expense of free and open source alternatives.
Need a multilingual dictionary tool that allows you to quickly translate words and expressions without leaving the convenience of OpenOffice.org? Drop in the EuroOffice.org Dictionary (EOD) extension.
In previous installments of the crash course, you've learned how to build a simple basket tool, a task manager, and even a word game. This time, let's take a look at how you can use the skills you picked up from those exercises to create a simple application launcher, which will allow you to start virtually any application without leaving the convenience of OpenOffice.org. While working on this project, you'll learn how to create and use functions, handle errors, and how to populate list boxes using records from a database table.
Wikis are a great way to collaborate on text documents, but different wikis sometimes use incompatible wiki markup languages, and few wikis provide simple WYSIWYG editors to shorten the learning curve. Even for those fluent in wiki markup, using a word processor to create wiki content is often more convenient -- especially for publishing existing documents and for creating complex tables. Now the newly available Sun Wiki Publisher simplifies the process of publishing an OpenOffice.org Writer document directly to a compatible MediaWiki wiki from OpenOffice.org 2.4 or later without the need for a Web browser.
Soothsayer is a predictive text input system. Many folks reading that sentence will think of the word completion offered by mobile phones. Soothsayer is different from such mobile phone systems in that it tries to use context and other statistical information to offer predictions instead of just presenting a list of words that might match the first few letters you type.
Do you fancy Web-based word processors but aren't ready to leave OpenOffice.org? You can work with your Zoho Writer and Google Docs files from the convenience of OpenOffice.org Writer, courtesy of the OoGdocsIntegrator extension.
The ability to import and export data is crucial to any database management system, and OpenOffice.org Base is no exception. While you may be surprised to discover that OpenOffice.org lacks a dedicated import/export feature, it does allow you to get data into and out of a database in a variety of ways.
In this age of multi-core processors and 3-D desktops, some people still get work done on old resource-strapped single-core machines, thanks to programs like the AbiWord word processor. The latest stable AbiWord 2.6.0 release was unveiled last month, two years after the software's last stable release. Feature-wise, the little cross-platform word processor has closed the gap with heavyweight OpenOffice.org Writer, but it suffers from the oldest Linux ill of all -- it's a pain to install.
With OpenOffice.org 2.4 just released, OpenOffice.org 3.0 (OOo3) has already passed its feature freeze, and is scheduled for release in September. Based on recent development builds, what can you expect? In the Base, Draw, and Math applications, very little change, at least so far. But in the core programs of Writer, Impress, and Calc, some long-awaited new features are arriving. Combined with the improvements in the charting system that are the major feature of the 2.4 release, these new features promise to increase both usability and functionality, although some of the changes do not go far enough.
Just because OpenOffice.org Basic is designed to automate mundane tasks doesn't mean that you must use it only for serious work. It's a programming language after all, and nothing stops you from using it to write something fun. Today we'll use it write a simple game where you have to guess a word, a letter at a time, from among words you've stored in a Base database. Although this is not a particularly sophisticated game, it contains a couple of string manipulation techniques and a clever trick for picking a random record from a database, which you might find useful when writing your own macros.
Over the last few years, OpenOffice.org has started to develop a respectable number of extensions, mostly for Writer and Calc, the two most widely used applications. The OpenOffice.org Extensions site lists only a handful that are unique to Impress. The recently released eVoice, which records sounds for direct insertion into a slide, is one of them. Once configured, eVoice is straightforward to learn, and becomes even more useful when you're working with other Impress features.
Although KOffice has its admirers, in many people's minds, it runs a poor second to OpenOffice.org. However, some European developers expect that situation to change, and to encourage that change, they have created KOfficeSource, a company incorporated in Germany. The company plans to offer support and training not only for KOffice, but also for Open Document Format, and programming using the Qt toolkit. The company's business plan highlights its founders' hopes that KDE-related technologies will become mainstream, and illustrates the current level of acceptance of free software tools in business.
Sun Presentation Minimizer (SPM) represents free software's answer to PPTminimizer. Designed for OpenOffice.org 2.3 or StarOffice 8 Impress and released under the Lesser GNU General Public License, SPM is an extension that creates a wizard that guides you through reducing the size of your presentation, making it easier to transport and, on some systems, quicker to run. Those who present large slide shows -- especially graphics-heavy ones -- will find it a well-designed and effective addition, although several features require more work.
ECMA, the international IT standards association, recently published its responses to comments of the ISO National Bodies in response to Microsoft's Office Open XML application for ISO standardization (the actual 2,293-page response is closed to the public). The ECMA proposals will be discussed at a Ballot Resolution Meeting (BRM) in Geneva after which the National Bodies may reconsider their original vote. Microsoft's responses make clear that within one year, it will have four different OOXML specifications to implement and interoperate with, and each of those specs will be closed. Under no circumstances should such a flawed specification become an international standard.
Apparently, the only thing that stopped developers from creating useful OpenOffice.org extensions was the lack of a place to publish them. With the launch of the OpenOffice.org Extension Repository, the number of extensions listed there has shot up, and there are no signs of a slowdown. Although quantity doesn't always mean quality, the repository already offers a few nifty extensions that can expand the functionality of OpenOffice.org and make your work more efficient.
In the recent accusations that the GNOME Foundation has been supporting Microsoft's OOXML format at the expense of ODF, KDE has been presented as a counter-example. Based on a KDE News article, Richard Stallman suggested that "major KDE developers" had announced "their rejection of OOXML" and urged GNOME to do the same. More recently, a widely linked story on ITWire used the same article to declare that KDE has taken a "principled stand" against OOXML. However, if you go the source, the story is more nuanced than these claims suggest.