Avery Label Templates for OpenOffice

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!

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5 out of 5)
Loading ... Loading ...

No Comments »
Filed under: Templates, Beginners

Updated Scaling Factor Spreadsheet

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)

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

No Comments »
Filed under: Calc, Intermediate

Scaling Spreadsheet Link Fixed

Thanks for the emails.

The Scaling Spreadsheet link is now fixed. Sorry for the inconvenience.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

No Comments »
Filed under: Calc, Intermediate

Collaborating with OpenOffice

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.

O3 Spaces Collaboration

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

No Comments »
Filed under: Useful Tools

Using OpenOffice Online in your Browser

UlteoFor 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

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

1 Comment »
Filed under: Online, Useful Tools, Intermediate, OpenOffice

Customising OpenOffice to play with Word

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.

Getting on… handshaking Word and OpenOffice Writer

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

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

No Comments »
Filed under: Intermediate, Writer, OpenOffice

Free Presentation Template - OpenOffice

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.

OzLady Stones - Free Presentation Template

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:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

2 Comments »
Filed under: Impress, Templates

FAQ: Portrait & Landscape Pagebreaks in OpenOffice

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…

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 4 out of 5)
Loading ... Loading ...

No Comments »
Filed under: Beginners, Writer, OpenOffice

FAQ: How do I set criteria for the COUNTIF Function?

The easiest way to do this is to use inverted commas with the statement to be tested against within the inverted commas.

COUNTIFThe 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.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

No Comments »
Filed under: Calc, Beginners

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 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.

 Visual Planner

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.5 out of 5)
Loading ... Loading ...

No Comments »
Filed under: Calc, Templates