Introducing Calc

From Apache OpenOffice Wiki
Jump to: navigation, search



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
Documentation note.png 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).
Personal tools