OpenOffice Calc Tips

In a previous entry we imported data from an HTML file on the local disk. In this example, we will extract stock quotes from an MSN site and import the data into OOo Calc spreadsheet.

(more…)

HLOOKUP is similar to the more often used VLOOKUP. To illustrate how the HLOOKUP could be used, we consider an example where we identify the minimum bid for a contract from a list of contractors.

(more…)

A picture tells a thousand words. In this introduction to OOo Calc charting capabilities, we will create a simple chart as an illustration of the operation of the charting AutoPilot.

(more…)

For statistical purposes, you may want to calculate the average of a data sample without its highest and lowest values.

(more…)

This tip explains how to determine whether the year in a date used in a OpenOffice Calc spreadsheet is a leap year.

(more…)