OpenOffice Calc Tips

When you cut and paste formulas from a range of cells, the cell references within the formulas will be automatically adjusted. Here, we show how to work aroud this ‘feature’.

(more…)

We present a simple macro that returns a random number with normal distribution.
(more…)

In this tip, we see how powerful SUMPRODUCT as an array function can be when doing condition summations.

In the example below, we wish to sum up any numbers in column D that correspond to the person referenced in C11. Whenever the value of the data in C3:C8 matches C11, the corresponding number in D3:D8 is added to the total.

D11 is an array formula, which is applied with CTRL - Shift - Enter

The Data Validation feature of OOo Calc is similar to that in Excel. It helps the user control the data that is entered in the spreadsheet where it may be necessary to do so.

(more…)

In the timesheet example below, to represent the total hours worked for the week, we use a custom time format [H]:MM

Cells E3:E7 are also formatted similarly. If we had used HH:MM, E3 for example would display 07:15 - which is not quite what we are looking for.

Cells C3:D7 are formatted HH:MM AM/PM

In this short tutorial, we will change the attributes of the chart title and the chart legend.

(more…)

How many of us have paid any attention to the row of small windows at the bottom of the OpenOffice Calc window? In this article, we will explore the Status Bar in more depth.

(more…)

The Navigator, as the name suggests, allows you to view the contents of a spreadsheet, sheets, ranges, linked areas, graphics objects, and notes.

(more…)