What is Calc?

Calc is the spreadsheet component of LibreOffice. 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 giving a wide range of 2D and 3D charts.

  • Macros for recording and executing repetitive tasks; scripting languages supported include LibreOffice 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 LibreOffice, you must first edit the code in the LibreOffice Basic IDE editor. For more information, see Chapter 12 Calc Macros in this guide or the Getting Started Guide.

results matching ""

    No results matching ""