Template: Date Planning

I was asked to put this template (link below) to assist in planning for multiple tasks or sessions that might be happening over a period of time, and the conditions that I had to conform to were as follows:

Fit a period of 3 months on a single page
Enter in the start date and all other […]

Sample Data

Sometimes I feel that it is useful to have sample data - and one of the hardest for me to put together on a whim is names. So I have put together a Calc spreadsheet, which has two sheets:

Sheet 1 has First Name and Last Name (2 columns)
Sheet 2 has Full Name (first and last […]

FAQ: What Word Processing Files Can OpenOffice Open?

The following screenshot from OpenOffice v2.3 shows the list of file types that are opened natively by OpenOffice.
Natively means without the support of any additional extensions or software.

Bookmark to:

FAQ: Is there a Format Painter in OpenOffice?

Yes there is and it can be applied in most of the OpenOffice applications. I am demonstrating it in Writer below, however the same steps are applied to cells in Calc.
1. Highlight the area from which you wish to copy the format from.

2. Click on the format painter icon in the toolbar.

3. When the mouse […]

FAQ: How do I perform a word count in OpenOffice?

Word count can be found in two ways:

File –> Properties, then click on the statistics tab

OR
Tools –> Word Count

The other useful application of this tool is to select the text that you wish to analyse, then select Tools –> Word Count to find out how many words in the selection.

Good luck with your work!
Bookmark to:

Mail Merge - without the address block

When you use the Tools –> Mail Merge Wizard in OpenOffice, it is quite limiting in that you are restricted to ending up with an address block. The way to insert other fields is not as obvious.
I have put together the tutorial below to guide you through my way of tackling a requirement of inserting […]

Concatenation in Calc

For those that aren’t familiar with the term, concatenation is the joining together of things - specifically side-by-side. This is often something that we wish to do, for example, if we have a first name and a family name.
EG. If we had the first name ‘David’ and the family name ‘Collier’ and we wanted to […]

FAQ: Where is File –> Page Setup?

One of the most criticised menu items of MS Office is the placement of the page formatting feature under File –> Page Setup. This is probably the biggest complaint and difficulty I’ve seen encountered when a user is transferring from MS Office to OpenOffice.
In OpenOffice, the page formatting is now located with the other formatting […]

Writer Tools - Extending OpenOffice Writer

Writer Tools, from No Thick Manuals, is a set of tools that will extend the functionality of OpenOffice’s word processor - Writer.
Some of the functionality includes:
- Looking up words in various online dictionaries and other tools
- Translation
- Mapping
- Emailing and Remote backup
- Saving in multiple formats
- Timers, Word hunt games
- A database to dynamically store […]

Blog from OpenOffice

It is not a free tool, however I see that Sun has developed an OpenOffice plugin that works with both OpenOffice and StafOffice, allowing you to post to a number of blogging platforms from within OpenOffice.
Checkout the Sun Weblog Publisher
Bookmark to: