Calc can either show the formula or the results of the formula.

Most of the time you will want to see the results of the formula, however occasionally, especially when you are troubleshooting, it is useful to display the formula itself for each cell.

To do this, follow the instructions below.

Be in a Calc file > Tools [...]

In response to the Singapore Public Holidays calendar, I’ve also compiled a Malaysian Public Holidays calendar. This was trickier as it had state holidays as well as National holidays. It’s my first go at the Malaysian holidays calendar, so if I get any wrong, please post politely in the comments – it was not intentional.

I [...]

A big thanks to suhaw who has volunteered a 2010 calendar. I wish I had seen it before I had updated mine! So I am hereby placing a link to both:

suhaw’s 2010 calendar with Singapore public holidays
ozlady’s 2010 calendar with Singapore public holidays

January 2010

Here is a template based on a church in India – Our Lady of Vailankanni.

Keeping it clean and neat, this photo with its clear, crisp skies allows your audience’s focus to be on your content.

Church Template – Title Slide

Church Template – Content Slide

[Download the Church Template here]

And [...]

An old-style telephone adds a monochromatic charm to this presentation.

I hope you like this one!

Communicate Presentation Template – Title Slide

Communications Presentation Template – Content Slide

[Download the Presentation Layout Here]

A friend of mine is familiar with working in Lotus 1-2-3 and has asked me for some assistance in converting to Excel or OpenOffice Calc. Of course I chose to post my Calc solutions here.

The formula for random number generation is quite easy.

=RAND()

This will get you a random number between zero and [...]

I recently saw a question regarding line breaks in the table of contents – OpenOffice does not allow you to edit a table of contents except through styles. Sometimes the way that long headings are formatted might not be what you desire.

One thing to note about the TOC is that the line breaks that you [...]

There is a good tutorial for Adding and Updating a Table of Contents in OpenOffice’s Writer over at OpenOfficeX.

Just a note before you jump to the link – it says that you can BUY OpenOffice – but they offer unlimited support for users. Note that OpenOffice is a free software – if you [...]

Click on the image below to download the Desk and Notepad template.

Calendar Templates for OpenOffice

I have had a fair interest in my modified Calendar Template with Singapore Public Holidays for 2009, so I thought I would post links to other calendar templates here.

Generic Calendar Template
Yearly Calendar Templates for Excel [...]