Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Functions by Category

This section describes the functions of Office Calc. The various functions are divided into categories in the Function Wizard.

Database

The twelve functions in the Database category help you to analyse a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.

Date & Time

These spreadsheet functions are used for inserting and editing dates and times.

Financial

This category contains the mathematical finance functions of Office Calc.

Information

This category contains the Information functions.

Logical

This category contains the Logical functions.

Mathematical

This category contains the Mathematical functions for Calc.

Array

This category contains the array functions.

Statistical

This category contains the Statistics functions.

Spreadsheet

This section contains descriptions of the Spreadsheet functions together with an example.

Text

This section contains descriptions of the Text functions.

Add-in

The following describes and lists some of the available add-in functions.