A lot of people think that most word-processing applications like Writer and its competition, are just like typewriters, with basic formatting like bold and underlining. This is OK for starting the document, but if it’s something that may require a format change in the future, then it could be a long and painful process.

Fortunately, [...]

Recently on my Facebook Page, I linked to a site that had a way to link to recipes that you have saved on your computer.

I decided to put together a sample downloadable spreadsheet that you could adapt to your own use, and I’ve included links to recipes on the web and [...]

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

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

A great deal of people using spreadsheets love using keyboard shortcuts.

Here are some selected Excel and Calc default keyboard shortcuts – and the difference in accessing the related functions. Below are some additional shortcut keys that are useful in Calc.

Function
Excel Shortcut
Calc Shortcut

Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) [...]

Just a quick post with a bit of a find: OpenOffice.org Ninja has a great post on how to share spreadsheets on a network, with updates and change conflict resolution.

Cooool

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

PC Mag suggests that we can Use Excel as an Architectural Design Tool.

So why not use Calc, as it has the advantage of being able to specify the ’squares’ quite easily, as row height and width is set using measures (cm or inches), rather than column width being set as a measure, and column [...]