Developer(s) | The Document Foundation |
---|---|
Stable release | |
Operating system | Linux, macOS, Microsoft Windows [3] and FreeBSD [4] |
Type | Spreadsheet |
License | MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0) [5] |
Website | www |
LibreOffice Calc is the spreadsheet component of the LibreOffice software package. [6] [7]
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. [8]
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. [6] Calc is also capable of saving spreadsheets as PDF files. [6]
As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows, [3] and FreeBSD. [4] Available under the Mozilla Public License, Calc is free and open-source software. [9] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS. [10] [11] 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. [12]
Capabilities of Calc include:
Originally called DataPilot, [8] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis. [21]
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. [18]
File format | Extension | Read/Write | Notes |
---|---|---|---|
Apple Numbers | NUMBERS | From 5.0 | |
Comma-separated values | CSV | Yes | |
Data Interchange Format | DIF | Yes | |
DBase, Clipper, VP-Info, | DBF | Yes | |
Gnumeric | GNM, GNUMERIC | From 5.1, cannot write | |
Lotus 1-2-3 | 123, WKS, WKS1, WK2, WK3, WK4 | Yes | |
Microsoft Excel 4/5/95 | XLS, XLW, XLT | Yes, writing up to 3.6 | |
Microsoft Excel 97–2003 | XLS, XLW, XLT | Yes | |
Microsoft Excel 2007-2021 | XLSX, XLTX, XLSM, XLTM | Yes | |
Microsoft Excel 2003 XML | XML | Yes | |
Microsoft Excel Web Query File | IQY | From 5.4 | |
Microsoft Pocket Excel | PXL | Yes | Requires Java |
OpenDocument (spreadsheet) | ODS, FODS, OTS, | Yes | |
OpenOffice.org XML (spreadsheet) | SXC, STC | Yes | |
Quattro Pro 6.0 | WB2, WQ1, WQ2 | Yes | |
StarOffice StarCalc 3/4/5 | SDC, VOR | Dropped in 4.0 then added back in 5.3, write up to 3.6 | |
SYLK | SLK | Yes |
Gnumeric is a spreadsheet program that is part of the GNOME Free Software Desktop Project. Gnumeric version 1.0 was released on 31 December 2001. Gnumeric is distributed as free software under the GNU General Public License; it is intended to replace proprietary spreadsheet programs like Microsoft Excel. Gnumeric was created and developed by Miguel de Icaza, but he has since moved on to other projects. The maintainer as of 2002 was Jody Goldberg.
Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.
Comma-separated values (CSV) is a text file format that uses commas to separate values, and newlines to separate records. A CSV file stores tabular data in plain text, where each line of the file typically represents one data record. Each record consists of the same number of fields, and these are separated by commas in the CSV file. If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks.
NeoOffice was an office suite for the macOS operating system developed by Planamesa Inc. It was a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program, and graphics program. It added some features not present in the macOS versions of LibreOffice and Apache OpenOffice. The last few versions were based on LibreOffice 4.4, which was released mid-2014.
The following tables compare general and technical information for a number of office suites:
A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.
OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets. OpenFormula is included in version 1.2 of the OpenDocument standard. OpenFormula was initially proposed and drafted by David A. Wheeler.
Data Interchange Format (.dif) is a text file format used to import/export single spreadsheets between spreadsheet programs.
Spreadsheet is a class of application software design to analyze tabular data called "worksheets". A collection of worksheets is called a "workbook". Online spreadsheets do not depend on a particular operating system but require a standards-compliant web browser instead. One of the incentives for the creation of online spreadsheets was offering worksheet sharing and public sharing or workbooks as part of their features which enables collaboration between multiple users. Some on-line spreadsheets provide remote data update, allowing data values to be extracted from other users' spreadsheets even though they may be inactive at the time.
LibreOffice is a free and open-source office productivity software suite, a project of The Document Foundation (TDF). It was forked in 2010 from OpenOffice.org, an open-sourced version of the earlier StarOffice. It consists of programs for word processing; creating and editing spreadsheets, slideshows, diagrams, and drawings; working with databases; and composing mathematical formulae. It is available in 120 languages. TDF does not provide support for LibreOffice, but enterprise-focused editions are available from companies in the ecosystem.
LibreOffice Writer is the free and open-source word processor and desktop publishing component of the LibreOffice software package and is a fork of OpenOffice.org Writer. Writer is a word processor similar to Microsoft Word and Corel's WordPerfect with many similar features, and file format compatibility.
LibreOfficeDraw is a free and open source vector graphics editor. It is one of the applications included in the LibreOffice office suite, developed by The Document Foundation.
Apache OpenOffice (AOO) is an open-source office productivity software suite. It is one of the successor projects of OpenOffice.org and the designated successor of IBM Lotus Symphony. It was a close cousin of LibreOffice, Collabora Online and NeoOffice in 2014. It contains a word processor (Writer), a spreadsheet (Calc), a presentation application (Impress), a drawing application (Draw), a formula editor (Math), and a database management application (Base).
Collabora Online is an open source online office suite built on LibreOffice technology, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.