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

Office Calc Features

Office Calc is a spreadsheet application that you can use to calculate, analyse and manage your data. You can also import and modify Microsoft Excel spreadsheets.

Calculations

Office Calc provides you with functions, including statistical and banking functions, that you can use to create formulae to perform complex calculations on your data.

You can also use the Function Wizard to help you create your formulae.

What-If Calculations

An interesting feature is to be able to immediately view the results of changes made to one factor of calculations that are composed of several factors. For instance, you can see how changing the time period in a loan calculation affects the interest rates or repayment amounts. Furthermore, you can manage larger tables by using different predefined scenarios.

Database Functions

Use spreadsheets to arrange, store and filter your data.

Office Calc lets you drag-and-drop tables from databases, or lets you use a spreadsheet as a data source for creating form letters in Office Writer.

Arranging Data

With a few mouse-clicks, you can reorganise your spreadsheet to show or hide certain data ranges, or to format ranges according to special conditions, or to quickly calculate subtotals and totals.

Dynamic Charts

Office Calc lets you present spreadsheet data in dynamic charts that update automatically when the data changes.

Opening and Saving Microsoft Files

Use the Office filters to convert Microsoft Excel files, or to open and save in a variety of other formats.