Top Qs
Timeline
Chat
Perspective

LibreOffice Calc

Spreadsheet component of LibreOffice From Wikipedia, the free encyclopedia

LibreOffice Calc
Remove ads

LibreOffice Calc is the spreadsheet component of the LibreOffice suite.[2][3]

Quick facts Developer, Stable release(s) ...

After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix many defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges.[4]

Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format.[2] Calc is also capable of saving spreadsheets as PDF files.[2]

As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows,[5] and FreeBSD.[6] Available under the Mozilla Public License, Calc is free and open-source software.[7] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS.[8][9] LibreOffice Online is an online office suite which includes the applications Writer, Calc and Impress and provides an upstream for projects such as commercial Collabora Online.

There is now a closed beta of LibreOffice on AmigaOS 4.1.[10]

Remove ads

Features

Capabilities of Calc include:

  • Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV,[11] and several other formats.[12][13]
  • Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.[14][15]
  • Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.[16] Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.[17] Version 7.4 made very large spreadsheets default.[18]
  • Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. LibreOffice Calc can use them.

Pivot Table

Originally called DataPilot,[4] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.[19]

An advanced sort macro is included that allows data to be arranged or categorised based on either a user generated macro or one of several default included macros.[16]

Remove ads

Supported file formats

More information File format, Extension ...
Remove ads

See also

References

Loading related searches...

Wikiwand - on

Seamless Wikipedia browsing. On steroids.

Remove ads