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

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

Here is another free template for presentations – I have created in in a ODP file as I am currently working out templates in OO3+.

Click on the image below to download the presentation. Enjoy!

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

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

Here is another free template for presentations – I have created in in a ODP file as I am currently working out templates in OO3+.

Click on the image below to download the presentation. Enjoy!

A new template from a photo that I took recently.

I hope it’s useful/appealing to some.

Shoes and Bricks Template – OpenOffice Impress

Update: I am starting to add more templates. You can view and download other free templates here.

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

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 Presentation Format – Stones

Download OzLady Stones Template (otp) file

There is no warranty or support offered for this presentation template. Comments are welcome and I [...]