I get really tired of fiddling with Avery Label templates in OpenOffice, and now there is a great resource that has it all done for you.
Check out the OpenOffice.org Label Templates (Asia & Europe) at World Labels. There are other label templates for other regions as well, so enter above and click the links. Great […]
No Comments »
Filed under: Templates, Beginners
I received the following question:
I used to insert a landscape style page in a document of portrait style pages and then re-continue using portrait pages. How can I do it in open office?
There are a number of ways to do this, usually involving setting your own page formats. One quick and simple solution is described […]
No Comments »
Filed under: Beginners, Writer, OpenOffice
The easiest way to do this is to use inverted commas with the statement to be tested against within the inverted commas.
The syntax is: COUNTIF(range; criteria)
The range is the range of the cells that you want to count (B2 to B21 in the screen shot provided).
The criteria is the requirement the range is to be […]
No Comments »
Filed under: Calc, Beginners
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
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
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
I can’t say it better than the Open Office team, so:
Introducing new functionality with OpenOffice.org 2.3!
OpenOffice.org 2.3 is available for download now! It includes several new features in addition to the usual improvements to stability, performance, Microsoft Office compatibility and Accessibility. Some of the new and exciting features are available as free extensions which increase […]
No Comments »
Filed under: Beginners, OpenOffice
I have been asked by a client to send them a generic invoice template. I have put together the template below, which is designed for services (it doesn’t include a ’ship to’), and is very simple.
Additionally, the Totals are all calculated automatically, and the formulae in Column H should not be changed if you wish […]
3 Comments »
Filed under: Calc, Templates, Beginners, OpenOffice
I have created a calendar template in Calc for a client.
The dates are automatically calculated. You only need to amend the first Sunday to achieve the date range that you need.
Download the file FREE from the following link:
Calendar Template File for OpenOffice 2.0
Bookmark to:
No Comments »
Filed under: Calc, Templates, Beginners
I have a number of clients who initially have problems understanding the page breaks within OpenOffice. In Microsoft Word we usually insert and then delete using the delete key or backspace.
Page breaks in OpenOffice do require a little bit more fiddling, but once you understand how pagebreaks work, then, in my opinion, you will find […]
1 Comment »
Filed under: Beginners, Writer
