OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung PDF herunterladen (Seite 10)

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 or sheet.

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; scripting languages

supported include OpenOffice.org Basic, Python, BeanShell, and JavaScript

• 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 12 (Calc Macros).

Spreadsheets, sheets, and cells

Calc works with elements 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 (65,536 rows in Calc

3.2 and earlier) and a maximum of 1024 columns

Parts of the main Calc window

When Calc is started, the main window looks similar to Figure 1.

Note

If any part of the Calc window in Figure 1 is not shown, you can display it

using the View menu. For example, View > Status Bar will toggle (show

or hide) the Status Bar. It is not always necessary to display all the parts,

as shown; show or hide any of them, as desired.

10 OpenOffice.org 3.3 Calc Guide

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 433 434

Keine Kommentare

OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung Seite 10