Īn 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. It is used for interactive table layout and dynamic data analysis. Originally called DataPilot, Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. were available only in Excel 2016 and later.

Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc.

Version 7.4 made very large spreadsheets default. Version 7.0 introduced 'very large spreadsheets' which can be enabled as an experimental feature.

Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.

Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.

Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV, and several other formats.

There is now a closed beta of LibreOffice on AmigaOS 4.1. 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. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS. There are community builds for many other platforms. Available under the Mozilla Public License, Calc is free and open-source software. Īs with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows, and FreeBSD. Calc is also capable of saving spreadsheets as PDF files.

Ĭalc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Īfter forking from 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.

LibreOffice Calc is the spreadsheet component of the LibreOffice software package. MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0) Linux, macOS, Microsoft Windows and FreeBSD

Libre excel