Posted on October 25th, 2007 by steph
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 […]
No Comments »
Filed under: Calc, Templates
Posted on October 23rd, 2007 by steph
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 […]
No Comments »
Filed under: Miscellaneous, Database
Posted on October 21st, 2007 by steph
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:
No Comments »
Filed under: Beginners, Writer, OpenOffice
Posted on October 19th, 2007 by steph
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 […]
4 Comments »
Filed under: Intermediate, OpenOffice
Posted on October 17th, 2007 by steph
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:
No Comments »
Filed under: Beginners, Writer
Posted on October 15th, 2007 by steph
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 […]
7 Comments »
Filed under: Advanced, OpenOffice
Posted on October 15th, 2007 by steph
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 […]
1 Comment »
Filed under: Calc, Intermediate
Posted on October 14th, 2007 by steph
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 […]
No Comments »
Filed under: FAQ, Beginners, OpenOffice
Posted on October 7th, 2007 by steph
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 […]
No Comments »
Filed under: Extensions, Writer, OpenOffice
Posted on October 6th, 2007 by steph
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:
No Comments »
Filed under: Writer, OpenOffice