

↑ 6.0 6.1 "Can I use a spreadsheet file with more than 32,000 rows?".↑ "Calc/hacks/number of rows - Wiki".Cite error: Invalid tag name "ooo3-max_cells" defined multiple times with different content ↑ 4.0 4.1 "What's the maximum number of rows and cells for a spreadsheet file?".Another FOSS application called Gnumeric provides easier access to these statistical analysis features by showing them to users with a wizard.
#Openoffice scalc software#
In some cases, Calc lacks a GUI to access certain advanced features that other spreadsheet software have, such as statistical abilities like error bar support on graphs, and polynomial regression analysis, however, many of these calculations can still be performed by manually entering the functions.
#Openoffice scalc mac os#
Available on many operating systems, including Microsoft Windows, Mac OS X, Linux, Unix, etc.Prior to V2.0, the limit on the number of rows was 32,000.

Version 2 of Calc was able to store a maximum of 65,536 rows with 256 columns in each sheet, with a maximum of 256 sheets. There is a way to increase these limits, but it is only suitable for ODF and text-based formats, as there is a risk of data turning unusable for binary formats such as Microsoft Excel's file format. Specifications Ĭalc can store a maximum of 65,536 rows with 1024 columns in each sheet, with a maximum of 256 sheets. Available under the Apache License, Calc is free software.

Just like the entire OpenOffice package, Calc can be used on many operating systems, including Mac OS X, Microsoft Windows, Linux, FreeBSD and Solaris. Calc also supports a wide range of other file formats, for both opening and saving files. The default file format for OpenOffice Calc version 2.x or 3.x can be set to either Microsoft Excel's native file format or the Open Document Format (ODF).
#Openoffice scalc pdf#
Calc is also capable of writing spreadsheets directly as PDF files. It provides a number of features not present in Excel, including a system which automatically defines a series for graphing based on the layout of the user's data. Calc is capable of opening and saving spreadsheets in Microsoft Excel's file format. OpenOffice Calc is the spreadsheet part of the OpenOffice software package.Ĭalc is similar to Microsoft Excel, with almost the same abilities. LGPL version 3 ( 2 Beta 2 and earlier are dual-licensed under the SISSL and LGPL) Īpache License 2.0 (Apache OpenOffice 3.4 and later)
