LibreOffice Calc

LibreOffice Calc
Name	LibreOffice Calc
Developer	The Document Foundation
Released	2011
Latest release	Varies by distribution
Programming language	C++, Python, JavaScript
Operating system	Linux, Windows, macOS
Genre	Spreadsheet
License	Mozilla Public License v2.0

LibreOffice Calc LibreOffice Calc is a spreadsheet application developed by The Document Foundation and distributed as part of the LibreOffice suite. It provides tools for numerical analysis, charting, pivot tables and formula management used in offices, scientific institutions and governments. Calc competes with proprietary products and interoperates with formats from companies, standards bodies and archives.

History

Calc originated as Forks of previous projects after a dispute involving developers and stakeholders tied to companies such as Sun Microsystems, Oracle Corporation and organizations like OpenOffice.org. The project matured alongside initiatives from communities associated with Debian, Fedora Project, Ubuntu, and contributors from firms such as Red Hat and SUSE. Its timeline intersects with events involving standards bodies including World Wide Web Consortium, International Organization for Standardization and archives like Internet Archive. Releases reflected influences from major software transitions at Microsoft Corporation during the era of Office 2010 and later, and legal contexts tied to foundations such as GNOME Foundation and Apache Software Foundation.

Features

Calc implements spreadsheet functions familiar to users of Microsoft Excel, supporting formula languages, statistical routines used in research at institutions like MIT and Stanford University, and charting capabilities akin to tools in Tableau Software and MATLAB. It includes pivot table equivalents comparable to PivotTable implementations seen in commercial suites used by corporations such as IBM and Siemens. Integration points include automation compatible with Python (programming language), macro patterns seen across projects such as LibreOffice Writer and interop with database engines such as MySQL, PostgreSQL, and SQLite. Calc supports large datasets handled in environments like CERN and visualization workflows common in labs at Harvard University and California Institute of Technology.

File formats and interoperability

Calc reads and writes the Open Document Format standardized by OASIS and follows versions influenced by ISO/IEC. It also imports and exports binary and XML formats originating from Microsoft Corporation including Office Open XML used in Microsoft Excel workbooks, and legacy formats associated with Lotus 1-2-3. Interoperability testing occurs in contexts involving archives such as National Archives (United Kingdom), libraries like Library of Congress, and consortia including OpenForum Europe to ensure compatibility with formats used by enterprises like Oracle Corporation and public administrations in European Commission member states.

User interface and customization

The user interface offers layouts similar to ribbon and toolbar paradigms familiar from Microsoft Office Fluent UI while supporting classic menu approaches popularized by projects like GNOME and KDE. Customization integrates with themes and icon sets maintained by distributions such as Ubuntu and openSUSE, and accessibility features align with guidelines from institutions including World Health Organization and standards from ISO. Localization is supported via contributions from communities linked to organizations like UNESCO and language projects coordinated by groups such as Wikimedia Foundation.

Extensions and scripting

Calc supports extensions packaged for distribution in ecosystems overseen by entities such as The Document Foundation and code hosted on platforms like GitHub and GitLab. Scripting can be done in Python (programming language), JavaScript, and macro languages comparable to those used in LibreOffice Basic. Automation and integration are used in workflows at companies including Siemens and Accenture, and in research pipelines at institutes like Max Planck Society and NASA.

Development and community

Development is coordinated by The Document Foundation with contributions from corporations such as Collabora and community projects supported by foundations like Mozilla Foundation and Eclipse Foundation. The codebase and translations are contributed by volunteers affiliated with universities such as University of Cambridge and firms like Canonical (company). Community governance draws on models used by Apache Software Foundation projects and collaborative events include conferences similar to FOSDEM and workshops akin to those organized by Linux Foundation.

Reception and usage

Calc has been adopted by public administrations in countries including members of the European Union and deployed in education systems in regions with projects linked to UNESCO and World Bank initiatives. Reviews in technology press have compared it against suites from Microsoft Corporation, Apple Inc. and cloud services from Google LLC. Organizations such as Wikipedia editors and non-profits like Electronic Frontier Foundation cite Calc in advocacy for open standards; enterprises including Red Hat and IBM reference it in migration case studies.

Category:Spreadsheet software Category:LibreOffice