LibreOffice_Calc

LibreOffice Calc

LibreOffice Calc

Spreadsheet component of LibreOffice

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

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

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]

Features

Capabilities of Calc include:

  • Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV,[13] and several other formats.[14][15]
  • Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.[16][17]
  • Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.[18] Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.[19] Version 7.4 made very large spreadsheets default.[20]
  • 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,[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]

Supported file formats

More information File format, Extension ...

See also

References

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

This article uses material from the Wikipedia article LibreOffice_Calc, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.