Posted on September 22nd, 2008 by steph
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 resource!

Loading ...
No Comments »
Filed under:
Templates,
Beginners
Posted on September 18th, 2008 by steph
A variation on the original scaling spreadsheet, this spreadsheet has standard deviation, average (mean) as well as grade scaling.
Updated Mark Scaling Spreadsheet (ideal for teachers)

Loading ...
No Comments »
Filed under:
Calc,
Intermediate
Posted on September 15th, 2008 by steph
Thanks for the emails.
The Scaling Spreadsheet link is now fixed. Sorry for the inconvenience.

Loading ...
No Comments »
Filed under:
Calc,
Intermediate
Posted on September 11th, 2008 by steph
If you are looking to enable document collaboration with check-in and check-out of resources and being able to do so from within the Open Office application, then check out O3 Spaces.


Loading ...
No Comments »
Filed under:
Useful Tools
Posted on February 12th, 2008 by steph
For those that need their docs on the go, but are not keep to go mainstream, then this may be an option for you.
Check the Javascript and Java requirements for browser compatibility (especially Linux users), but it seems like a very viable option!
Try Ulteo

Loading ...
1 Comment »
Filed under:
Online,
Useful Tools,
Intermediate,
OpenOffice
Posted on February 7th, 2008 by steph
This is some reading that I found recently that makes it easier for OpenOffice and Word to exchange files a little more seamlessly. This has become more important as I am consulting in an environment that is a strict MS user - and being able to have documents that open seamlessly in the MS Word applications is probably the trickiest aspect of being an OpenOffice user.

It suggests that you tweak a number of default options with regards to saving and use of VBA, as well as other compatibility settings. I hope that it assists with some of your issues.
Make sure Word, OpenOffice.org Writer play well together

Loading ...
No Comments »
Filed under:
Intermediate,
Writer,
OpenOffice
Posted on January 20th, 2008 by steph
I saw a nice presentation template at a conference recently, so I decided to design a template based on this. Here is my first attempt.

Download OzLady Stones Template (otp) file.
There is no warranty or support offered for this presentation template. Comments are welcome and I may include suggestions in any future templates I put together. I hope you find it useful.
If you need help in implementing presentation template in OpenOffice (and designing one of your own), go to the following link:

Loading ...
2 Comments »
Filed under:
Impress,
Templates
Posted on January 14th, 2008 by steph
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 below.
Read more…

Loading ...
No Comments »
Filed under:
Beginners,
Writer,
OpenOffice
Posted on January 4th, 2008 by steph
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 tested against in order to be counted (if the requirement tested is true) . This is the “>=35″ in the screen shot.
Don’t forget to include the inverted commas “” or otherwise you will get an error.

Loading ...
No Comments »
Filed under:
Calc,
Beginners
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 dates are calculated
- Daily slots (a space for each day)
- Be able to plan for two tasks (or subjects) on the same timeline
The link below was a simple planner that we settled on.
Please let me know if you find this useful, or have any amendments or suggestions that you think would make this better.
Simple Three Month Schedule Planner
Surprisingly, it works well in meetings as it can be printed out and used for planning dates on a timeline.


Loading ...
No Comments »
Filed under:
Calc,
Templates