LibreOffice Calc

LibreOffice Calc
DeveloperThe Document Foundation
Stable release(s)
  • Fresh: 26.8.2 / 29 October 2026 Edit this on Wikidata
  • Still: 26.2.7 / 3 November 2026 Edit this on Wikidata
Preview release(s)
27.2.0.0.alpha0 / 16 June 2026 Edit this on Wikidata
Operating systemCross platform
TypeSpreadsheet
LicenseMPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)
Websitelibreoffice.org/discover/calc
Repository

LibreOffice Calc is the spreadsheet component of the LibreOffice suite.

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.

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

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

Features

Capabilities of Calc include:

Pivot Table

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

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.

Supported file formats

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,

FoxPro

 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

See also

References

  1. ↑ Italo Vignoli (29 October 2026). "LibreOffice 26.8.2 improves stability, multimedia and compatibility". Retrieved 29 October 2026.
  2. ↑ Italo Vignoli (3 November 2026). "LibreOffice 26.2.7 is available for download". Retrieved 4 November 2026.
  3. ↑ "Index of /daily/master/". Retrieved 5 August 2026.
  4. ↑ "Licenses". The Document Foundation. Retrieved 16 December 2015.
  5. 1 2 3 "Calc, the LibreOffice spreadsheet program". The Document Foundation. Retrieved 8 September 2011.
  6. ↑ Petersen, Richard (2011). Ubuntu 11. 04 Desktop Handbook. Surfing Turtle Press. p. 170. ISBN 978-1-936280-28-5.
  7. 1 2 "3.4 New Features and Fixes". The Document Foundation. Archived from the original on 14 December 2013. Retrieved 8 September 2011.
  8. ↑ The Document Foundation (n.d.). "System Requirements". Retrieved 8 September 2011.
  9. ↑ FreeBSD Handbook, 7.3.5 LibreOffice
  10. ↑ "Licenses". The Document Foundation. Retrieved 21 June 2011.
  11. ↑ "Collabora Office". Google Play. Retrieved 7 May 2023.{{cite web}}: CS1 maint: deprecated archival service (link)
  12. ↑ "Collabora Office". Apple App Store. 2023. Retrieved 7 May 2023.{{cite web}}: CS1 maint: deprecated archival service (link)
  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.