Getting Started with Apache OpenOffice Version 3.4 Chapter 4 Getting Started with Calc Using Spreadsheets in Apache OpenOffice

Abstract

Calc is the spreadsheet component of Apache OpenOffice. You can enter data (usually numerical) in a spreadsheet and then manipulate this data to produce certain results. Alternatively you can enter data and then use Calc in a ‘What if...’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet. Other features provided by Calc include: Functions, which can be used to create formulas to perform complex calculations on data, Database functions, to arrange, store, and filter data, Dynamic charts, a wide range of 2D and 3D charts, Macros, for recording and executing repetitive tasks, Ability to open, edit, and save Microsoft Excel spreadsheets, Import and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript.