The free and open source office suite OpenOffice.org might be a killer app for many, but its inability to properly display documents created in the proprietary Microsoft Office formats hinders its widespread acceptance in multi-OS business environments with many legacy .doc and .xls files. If changing over to an open document format is not an option, try SoftMaker Office. It's no OpenOffice.org-killer, but it's a full featured office suite that has great compatibility with Microsoft Office. Sure, it costs $80, but you can increase your karma by running it on Linux.
StarOffice 9 reminds me of the classic Monty Python skit in which Graham Chapman wrestles himself. Although StarOffice is being aggressively presented as an alternative to Microsoft Office, it seems to be equally marketed and bundled to compete against OpenOffice.org, the free software project that is sponsored by Sun and that shares a common code base with StarOffice. The trouble is, the differences between the two have diminished with each release, until, with StarOffice 9, you have to wonder who the potential customers might be.
Kraft helps you keep track of business offers and invoices and can generate PDF files to help you easily issue these routine documents to third parties. Since Kraft is a KDE application, it can draw contact information directly from your KDE address book, so you don't have to duplicate or sync your contacts in order to generate an invoice.
Currently in late beta, the Sun Presenter Console (SPC) is Sun Microsystems' latest extension for OpenOffice.org and StarOffice. Other extensions from Sun in the last year, such as the Sun PDF Import Extension, Sun Presentation Minimizer, and Sun Weblog Publisher, have sometimes been lacking in design and sometimes buggy, but all of them are so invaluable that you might wonder why they are extensions instead of new features. SPC is no exception. It gives slide show presenters a separate view of their presentation and some tools to help them organize and deliver their talks, but includes no indication of how to set it up or use it.
If you want to keep tabs on your deadlines, you don't need a fancy project management application -- often, a simple spreadsheet can do the job. To see how, let's create a spreadsheet that tracks task deadlines, shows the current status of each task, and highlights scheduling conflicts. In the process we'll learn a few useful Calc techniques.
OpenOffice.org Writer is as much a desktop publishing program as a word processor. That fact, however, has yet to have much influence on the extensions created for Writer -- perhaps because most users prefer manual formatting to organizing themselves with page styles, templates, and other elements of document design. Still, extensions for layout are starting to appear, as demonstrated by four extensions that help you automate layout: Alba, which manages page orientation; Pagination and Pager, which manage page numbering; and Template Changer, which allows you to change the template, and therefore the entire layout of documents, on the fly. And all but one of these extensions use styles and templates, the way that OpenOffice.org is built to work, which means that they are highly stable.
OpenOffice.org 3.0, which is being released today, is not the great leap forward in look and feel that version 2.0 represented, but it justifies its label as a major release with dozens of changes, some major, some minor, but in all more than can be easily summarized.
The Sun Report Builder extension adds powerful reporting capabilities to OpenOffice.org Base, and using it to create reports is easy, as we can see with a simple example. Suppose you're a freelance writer, and you want to keep track of your submissions using a simple OpenOffice.org Base database that stores article titles, publications, submission dates, current status, and payment rates. This is a useful solution, but adding reporting capabilities turns the database into a handy analytical tool. With Sun Report Builder you can generate a list of articles grouped by publication, shows the sum of article payments, and displays a chart of payments for each publication.
Yesterday, I looked at the major applications in the first beta for KOffice 2.0. Now it's the turn of the rest of the beta: The KPlato project manager, KChart, the vector graphics editor Karbon, and the raster graphics editor Krita.
KOffice has been trailing the office application leaders for a long time. Despite years of development, it has yet to match OpenOffice.org feature for feature, although its features are complete enough that they have attracted a loyal community. Judging from the first beta, KOffice 2.0 will still not rival OpenOffice.org or other free software rivals, but it should be a major step in that direction.
Open.Amsterdam (in Dutch; English PDF download available here) is working to convert most of the city of Amsterdam's computers to GNU/Linux and open source software, and to make sure that any remaining proprietary-OS computers owned by the city use open file formats instead of closed, proprietary ones. In this interview, project director Manuo Chen tells us how the project is going and a little about its goals -- and a little about some of the pitfalls it has encountered, too.
Mail merge, the production of multiple documents that differ only in minor details, remains a difficult task in OpenOffice.org Writer. Few use the function regularly, and when they do, the mail merge wizard seems to cause as much confusion as it resolves. Writer's original mail merge feature, retrievable from Tools -> Customize -> Add -> Documents -> Mail Merge is somewhat more straightforward, but, even with it, users are likely to confuse the original document and the information source. In comparison to those other alternatives, FastMailMerge is not only simplicity itself, but a welcome relief that easily lives up to its name.
The ability to save user settings can come in handy if you want to make your OpenOffice.org solutions more flexible, efficient, and user-friendly. In this article, we take a look at how to save user settings in a plain text file and then retreive them from there.
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.