LibreOffice Calc

Last updated

LibreOffice Calc
Developer(s) The Document Foundation
Stable release
  • Fresh: [1] 7.5.5 [2]   OOjs UI icon edit-ltr-progressive.svg (20 July 2023)
  • Still: [1] 7.4.7 [3]   OOjs UI icon edit-ltr-progressive.svg (11 May 2023) [±]
Operating system Linux, macOS, Microsoft Windows [4] and FreeBSD [5]
Type Spreadsheet
License MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0) [6]
Website www.libreoffice.org/discover/calc/

LibreOffice Calc is the spreadsheet component of the LibreOffice software package. [7] [8]

Contents

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. [9]

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

As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows, [4] and FreeBSD. [5] Available under the Mozilla Public License, Calc is free and open-source software. [10] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS. [11] [12] 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. [13]

Features

Capabilities of Calc include:

Pivot Table

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

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. [19]

Supported file formats

File formatExtensionRead/WriteNotes
Apple Numbers NUMBERSFrom 5.0
Comma-separated values CSVYes
Data Interchange Format DIFYes
DBase, Clipper, VP-Info,

FoxPro

DBFYes
Gnumeric GNM, GNUMERICFrom 5.1, cannot write
Lotus 1-2-3 123, WKS, WKS1, WK2,

WK3, WK4

Yes
Microsoft Excel 4/5/95XLS, XLW, XLTYes, writing up to 3.6
Microsoft Excel 97–2003XLS, XLW, XLTYes
Microsoft Excel 2007-2021XLSX, XLTX, XLSM,

XLTM

Yes
Microsoft Excel 2003 XMLXMLYes
Microsoft Excel Web

Query File

IQYFrom 5.4
Microsoft Pocket ExcelPXLYesRequires Java
OpenDocument

(spreadsheet)

ODS, FODS, OTS,Yes
OpenOffice.org XML

(spreadsheet)

SXC, STCYes
Quattro Pro 6.0WB2, WQ1, WQ2Yes
StarOffice StarCalc 3/4/5SDC, VORDropped in 4.0 then

added back in 5.3, write up to 3.6

SYLK SLKYes

See also

Related Research Articles

<span class="mw-page-title-main">Gnumeric</span> Free and open-source spreadsheet software

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.

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft Office

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.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

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.

<span class="mw-page-title-main">OpenOffice.org</span> Discontinued free office software

OpenOffice.org (OOo), commonly known as OpenOffice, is a discontinued open-source office suite. Active successor projects include LibreOffice, Apache OpenOffice, Collabora Online and NeoOffice.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice is an office suite for the macOS operating system developed by Planamesa Inc. It is a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program and graphics program, it adds some features not present in the macOS versions of LibreOffice and Apache OpenOffice. Current versions are 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 grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values.

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

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.

This is a comparison of word processing software.

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.

<span class="mw-page-title-main">LibreOffice</span> Free and open-source office software suite

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. The LibreOffice suite consists of programs for word processing, creating and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulas. It is available in 115 languages. TDF does not provide support for LibreOffice, but enterprise-focused editions are available from companies in the ecosystem.

<span class="mw-page-title-main">LibreOffice Writer</span> Open-source word processor

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.

<span class="mw-page-title-main">LibreOffice Draw</span> Vector graphics editing software

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.

<span class="mw-page-title-main">Apache OpenOffice</span> Free and open-source office software suite

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).

<span class="mw-page-title-main">Collabora Online</span> Online office suite based on LibreOffice

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.

References

  1. 1 2 https://www.libreoffice.org/download/download/
  2. Mike Saunders (20 July 2023). "LibreOffice 7.5.5 Community available for download" . Retrieved 21 July 2023.
  3. "Announcement of LibreOffice 7.4.7 Community". 11 May 2023. Retrieved 11 May 2023.
  4. 1 2 The Document Foundation (n.d.). "System Requirements" . Retrieved 8 September 2011.
  5. 1 2 FreeBSD Handbook, 7.3.5 LibreOffice
  6. "Licenses". The Document Foundation . Retrieved 16 December 2015.
  7. 1 2 3 "Calc, the LibreOffice spreadsheet program". The Document Foundation . Retrieved 8 September 2011.
  8. Petersen, Richard (2011). Ubuntu 11. 04 Desktop Handbook. Surfing Turtle Press. p. 170. ISBN   978-1-936280-28-5.
  9. 1 2 "3.4 New Features and Fixes". The Document Foundation. Archived from the original on 14 December 2013. Retrieved 8 September 2011.
  10. "Licenses". The Document Foundation . Retrieved 21 June 2011.
  11. "Collabora Office". Google Play . Archived from the original on 31 December 2022. Retrieved 7 May 2023.
  12. "Collabora Office". Apple App Store . 2023. Archived from the original on 5 October 2020. Retrieved 7 May 2023.
  13. "New beta LibreOffice for AmigaOS 4.1". GenerationAmiga.com. 28 February 2017. Archived from the original on 2 December 2019. Retrieved 12 December 2018.
  14. "Importing and Exporting CSV Files". LibreOffice Help. The Document Foundation . Retrieved 8 September 2011.
  15. "About Import and Export Filters". LibreOffice Help. The Document Foundation . Retrieved 8 September 2011.
  16. "The Document Foundation, LibreOffice and OOXML". The Document Foundation Wiki. The Document Foundation . Retrieved 8 September 2011.
  17. "Financial Functions Part One". LibreOffice Help. The Document Foundation . Retrieved 8 September 2011.
  18. "Add-in Functions, List of Analysis Functions Part Two". LibreOffice Help. The Document Foundation . Retrieved 8 September 2011.
  19. 1 2 "3.3 New Features and Fixes". LibreOffice. The Document Foundation. 2011. Archived from the original on 27 February 2014. Retrieved 29 July 2011.
  20. "50916 – Allow more than 1024 columns in calc". bugs.documentfoundation.org. Retrieved 4 May 2022.
  21. "LibreOffice 7.4 Community: Release Notes - The Document Foundation Wiki". wiki.documentfoundation.org. Retrieved 28 January 2023.
  22. "Pivot Table". LibreOffice Help. The Document Foundation . Retrieved 13 November 2011.