OpenOffice.org OpenOffice - 3.3 Guide de démarrage rapide télécharger pdf (Page 106)

What is Calc?

Calc is the spreadsheet component of OpenOffice.org (OOo). 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

Note

If you want to use macros written in Microsoft Excel using the VBA

macro code in OOo, you must first edit the code in the OOo Basic IDE

editor. See Chapter 13 (Getting Started with Macros) in this book and

Chapter 12 in the Calc Guide.

Spreadsheets, sheets and cells

Calc works with documents called spreadsheets. Spreadsheets consist of a number of

individual sheets, each sheet containing cells arranged in rows and columns. A

particular cell is identified by its row number and column letter.

Cells hold the individual elements—text, numbers, formulas, and so on—that make up

the data to display and manipulate.

Each spreadsheet can have many sheets, and each sheet can have many individual

cells. In Calc 3.3, each sheet can have a maximum of 1,048,576 rows (65,536 rows in

Calc 3.2 and earlier) and a maximum of 1024 columns.

106 Getting Started with OpenOffice.org 3.3

1 2 ... 101 102 103 104 105 106 107 108 109 110 111 ... 378 379

Pas de commentaire

OpenOffice.org OpenOffice - 3.3 Guide de démarrage rapide Page 106