Introducing Calc
From Apache OpenOffice Wiki
- What is Calc?
- Spreadsheets, Sheets, and Cells
- Parts of the Main Calc Window
- Starting New Spreadsheets
- Opening Existing Spreadsheets
- Opening CSV Files
- Saving Spreadsheets
- Password Protection
- Navigating within Spreadsheets
- Selecting Items in a Sheet or Spreadsheet
- Working with Columns and Rows
- Working with Sheets
- Viewing Calc
- Using the Navigator
- Using Document Properties
What is Calc?
Calc is the spreadsheet component of Apache OpenOffice (AOO). In a spreadsheet, you enter data, usually numerical, and then manipulate that data to produce certain results.
Alternatively, you can enter data and then use Calc in a ‘What if…’ manner by changing some data and observing the results, without having to retype the entire spreadsheet.
Other features provided by Calc include:
- Functions, which can create formulas that perform complex calculations on data
- Database functions that arrange, store, and filter data, both numerical and textual
- Dynamic charts: a wide range of 2D and 3D charts that can change as the data upon which they are based changes
- Macros for recording and executing repetitive tasks. The supported programming or scripting languages include OpenOffice Basic, Python, BeanShell, and JavaScript
- Ability to open, edit, and save Microsoft Excel spreadsheets. Files in the more recent XLSX format can be opened, but they'll be saved in the older XLS format.
- Import and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript
| If you want to use macros written in Microsoft Excel using VBA macro code, you must first edit the code in the AOO Basic IDE editor. See Chapter 12 (Calc Macros). |
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |