Introducing Calc

From Apache OpenOffice Wiki
Jump to: navigation, search

This is Chapter 1 of the 3 Calc Guide, produced by the ODFAuthors group. A PDF of this chapter is available from this wiki page.

What is Calc?

Calc is the spreadsheet component of (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; two new types of charts—Bubble Charts and Filled Net Charts—have been introduced in OOo 3.2
  • Macros, for recording and executing repetitive tasks; scripting languages supported include 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
Documentation note.png 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.

Spreadsheets, sheets, and cells

Calc works with documents called spreadsheets. Spreadsheets consist of a number of individual sheets, each containing cells arranged in rows and columns. A particular cell is identified by its column letter and row number.

These 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.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools