OpenOffice

Resounding success for Openness

The hugely popular Economist magazine in its prediction for the year 2008 says that Linux is going to grow big and this time - it is not a fad! With the success of Ubuntu and the various other alternatives to Microsoft software it offers a real cost saving that is making small business and home buyers re-think on blindly investing in Microsoft products...

Use OpenOffice.org online with Ulteo !

The latest version of OpenOffice.org is now available using a browser with a single click of a mouse, with no download or installation process ('no install') of the productivity suite required. This new service by Ulteo offers many benefits for users of the productivity suite, and has been well received by early beta users across Windows, Linux and Mac operating systems.

How to make a daily calendar with OOo

When I hear "mail merge," I usually think of personalizing letters and printing envelopes. However, many other projects can make use of mail merge. This year I tackled a new Christmas gift project by using mail merge in OpenOffice.org (OOo) to create a tear-off daily calendar, personalized with holidays and family events. Here's how.

OpenOffice.org 2.3 Impresses

The release of OpenOffice.org 2.3 brings several significant improvements to the open-source office productivity suite, including easier upgrade paths for existing Microsoft Office users, improved measures to prevent security breaches, and an array of snazzy new features introduced in the suite's word processing, spreadsheet, presentation and database applications.

Openoffice.org 2.3 color palette

You can add custom colors with > Tools > Options > Openoffice.org > Colors. In this process, OOo crashed down on me this morning (I’m running Gutsy and using OOo from Ubuntu repos). It would run again, reopen the files, but all the color palette for text or objects was gone gone gone.

OpenOffice’s presentation view

Currently OpenOffice’s presentation program Impress lacks a presentation view with notes and so on for a second monitor during presentations. But the feature is in active development, and first results are visible.

Using the Advanced Filter

Here's your data. Click the image to see it larger. [image] Now, here's how you enter your critera. Copy your headings and paste them somewhere else in the spreadsheet. Then type the values you want. Click this image to see it larger.

Back up and print your blog with OpenOffice.org Base

If you are running a blog (or any Web publishing system, for that matter) that relies on a database back end, you will sooner or later face the problem of backing up the content stored in the database. One way to go about it is to build a backup tool using OpenOffice.org Base. Since Base can pull data from a MySQL or any ODBC-compliant data source, you can create a simple database that connects to the blog's back end and extracts content from it, which you can then export in different formats.

Things that control how content is displayed in OpenOffice.org Calc spreadsheets

If you spend all day in spreadsheets, sooner or later you want something to help you spot what's important or different. The motion study expert Frank Gilbreth told factories to paint parts different colors to help factory workers spot the right pieces more quickly; Calc has roughly equivalent features to help point out the different types of data you're working with.

Summary of new features in OpenOffice.org 2.3

Here’s a summary of the features from the 2.3 new features list that I considered the most useful or important to write about. This page  http://wiki.services.openoffice.org/wiki/New_Features_2.3 about the new features is an excellent guide, as well.

Sun Report Builder: Better reporting in OpenOffice.org

OpenOffice.org Base is undoubtedly a powerful database application, but when it comes to its built-in reporting engine, words like "underpowered" and "outdated" come to mind. Fortunately, you don't have to put up with this situation any longer: with the Sun Report Builder (SRB) extension, you can add nifty reporting features based on Pentaho reporting engine -- assuming you can figure out how to use it without any help.

Welcome back, user-defined motion paths in OpenOffice Impress 2.3

Back in the good old days of 1.x, you could draw a line, then draw an object, and make the object move along whatever line that was. It was great.

Then the lovely redesign of Impress came, and that user-defined motion path feature got lost along the way.  It was a sad time.

Using Zotero to manage OpenOffice.org bibliographies

If OpenOffice.org's own bibliography feature doesn't really cut it for you, you have several choices. One popular bibliography solution is Bibus, a cross-platform tool that integrates nicely with OpenOffice.org. It is, however, not the only bibliographical tool out there. In fact, there is another nifty tool called Zotero that turns Firefox into a powerful research tool. More importantly, it comes with an OpenOffice.org extension that allows you to use Zotero as a bibliography database. Zotero also sports a few clever features that make the process of creating and managing bibliographies much more efficient.

OpenOffice 3.0 Wants to Compete with Outlook

I was just over at the OpenOffice site browsing through some of their marketing materials to see if there was anything interesting. I came across a presentation that was given on September 19th at the OpenOffice 2007 Conference. The presentation was called “OpenOffice.org 3.0 and Beyond,” and it walked through some of the most notable features that are expected to be released in the next big OpenOffice milestone.

A simple task manager for OpenOffice.org

If you spend most of your time in OpenOffice.org, you might want to be able to manage to-do lists and tasks without leaving the comfort of the office suite. Since Writer doesn't have such a feature, you can create your own no-frills task tool and at the same time sharpen your OOoBasic skills.

Office shootout: OpenOffice.org Calc vs. Microsoft Excel

In earlier articles, I compared OpenOffice.org 2.3's and MS Office 2007's word processors and slide show programs. It seems appropriate to round off the comparison with a look at spreadsheets, the third of the core programs in any office application.

Sweet Symphony is out of tune with OOo

Last month, just one week after IBM announced it would help with OpenOffice.org's development, the company released Lotus Symphony, an office suite based on OpenOffice.org code. I found a lot of slick features in Lotus Symphony, but I worry that Symphony could affect the OpenOffice.org community adversely.

Office shootout: OpenOffice.org Impress vs. Microsoft PowerPoint, round 2

How does the current version of OpenOffice.org (OOo) compare with Microsoft Office in its ability to produce slide presentations? The last time I tried to answer that question, two years ago, both OOo Impress and Microsoft PowerPoint had features that the other lacked. To see how the two programs compare now, I installed Microsoft Office 2007 and OpenOffice.org 2.3, and went through the process of designing a slide show from start to finish. To my surprise, the results were more decisive than in my last comparison. They're not enough to award a knockout victory, but, even based on points, the winner is clear.

OpenXML (docx,…) suport in OpenOffice

I’m starting to get .docx in my mail lately ( against my will…) and not using Microsoft Office and not beeing able to ask people to send at least .doc, I had to do some search to give some support do OpenOffice to this “format”.

Adding a basket tool to OpenOffice.org

No matter whether you are working on an article, an academic paper, or a novel, research is a crucial part of the writing process. And as with any research, you need a place to save your notes, ideas, relevant links, and text snippets. While there are tools like Basket Note Pads and the Zotero Firefox extension, wouldn't it be nice if you could store and manage your stuff directly from within OpenOffice.org? This is not only doable, but also easy to implement using just a Base database and a macro.

Syndicate content