LibreOffice Calc is a spreadsheet component of the LibreOffice software package.
After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix a large number of defects in formula calculations involving external references, and to improve data cache performance especially when referencing large data ranges.
Additionally Calc now supports 1 million rows in a spreadsheet with macro references to each cell.
Calc is able to open and store most of the spreadsheets in Microsoft Excel file format. Calc is also capable of storing spreadsheets as PDF files.
As with all LibreOffice packages, Calc is available for various platforms, including Linux, OS X, Microsoft Windows, and FreeBSD. Available under the Mozilla Public License, Calc is free and open source software.
Now there is a closed beta from LibreOffice on AmigaOS 4.1.
Video LibreOffice Calc
Features
Calc's capabilities include:
- Ability to read/write OpenDocument (ODF), Excel (XLS), CSV and several other formats.
- Supports a large number of functions, including functions for imaginary numbers, as well as financial and statistical functions.
- Supports 1 million rows in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets. However, the number of columns is limited to at most 1024, much lower than the 16384 Excel limit.
In the internal data structure, Calc up to version 4.1 depends on the cell as the base class throughout, which has been blamed for "extreme memory usage, slow calculation, and hard codes". Version 4.2 (released in January 2014) solved this problem instead of storing data in arrays where possible.
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.
Pivot tables have support for unlimited fields. Previous Pivot Table only supports up to 8 columns/rows/data fields and up to 10 page fields.
Advanced sorting macros are included that allow data to be organized or categorized based on user-generated macros or one of several included macros by default.
Maps LibreOffice Calc
Releasing the history
Calc continues to deviate since the fork of its parent OpenOffice with new features are added and code cleaning is happening.
The version for LibreOffice Calc includes the following:
See also
- List of spreadsheets
- Spreadsheet comparison
References
External links
- Official website
Source of the article : Wikipedia
0 Comments