OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 133)

100

101

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.x, each sheet can have a maximum of

65,536 rows and a maximum of 1024 columns, for a total of over 67

million cells.

Chapter 5 Getting Started with Calc 133

Free eBook Edition

1 2 ... 128 129 130 131 132 133 134 135 136 137 138 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 133

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 133

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.2