OpenOffice.org Calc is the spreadsheet component of the OpenOffice.org software package.
Calc is similar to Microsoft Excel, with a roughly equivalent range of features. Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. It provides a number of features not present in Excel, including a system that automatically defines series for graphing based on the layout of the user's data. Calc is also capable of writing spreadsheets directly as PDF files.
The default file format for OpenOffice.org Calc (versions 2.x and 3.x) can be set to either Microsoft Excel's native file format or the international standard OpenDocument Format (ODF) ISO/IEC 26300:2006. Calc also supports a wide range of other file formats, for both opening and saving files, such as CSV, HTML, SXC, DBF, DIF, UOF, SLK, SDC and others.[1]
As with the entire OpenOffice.org suite, Calc can be used across a variety of platforms, including Mac OS X, Microsoft Windows, Linux, FreeBSD and Solaris. Available under the GNU Lesser General Public License, Calc is free software.
Contents |
Specifications
Calc 3.0 can store a maximum of 65,536 rows with 1,024 columns in each sheet, with a maximum of 256 sheets.[2] There is a work-around to increase these limits, but it is only suitable for ODF and text-based formats, as there is a risk of data corruption for binary formats such as Excel's native format.[3] In Calc 3.0.0, the column limit has been increased to 1024 from 256 used in older versions.[4] Prior to V2.0, the limit on the number of rows was 32,000.[5]
This list is incomplete; you can help by expanding it.| Program | Rows (per sheet) | Columns (per sheet) | Total Cells (per sheet) | Sheets |
|---|---|---|---|---|
| Gnumeric | 65,536[6] | 256[6] | 16,777,216 | |
| KSpread | 32,767 | 32,767 | 1,073,676,289 | |
| Lotus 1-2-3[7] | 65,536 | 256 | 16,777,216 | 256 |
| Microsoft Excel 2003[8] | 65,536 | 256 | 16,777,216 | |
| Microsoft Excel 2007[9] | 1,048,576 | 16,384 | 17,179,869,184 | Available Memory [10] |
| OpenOffice.org Calc[11][12][13][14] | 65,536 (in 2.x.x/3.x.x) 32,000 (in 1.x.x) | 1,024 (in 3.x.x) 256 (in 1.x.x/2.x.x) | 67,108,864 (in 3.x.x) 16,777,216 (in 2.x.x) 8,192,000 (in 1.x.x) | 256 |
| Quattro Pro | 1,000,000 | 18,276 | 18,276,000,000 |
Special capabilities
Capabilities of Calc include:
- Open source software
- Available on many platforms, including Windows, MacOS, Linux, Unix, etc.
- Ability to read/write OpenDocument (ODF), Excel (XLS), CSV, and several other formats.
- Able to handle dates on or before 1900 correctly (many spreadsheet applications, including Excel, have a year 1900 bug and cannot handle dates before January 1, 1900).
- Support for a large number of functions, including those for imaginary numbers, as well as financial and statistical functions.
Missing features
In some cases, Calc lacks the GUI wizard to access certain advanced features associated with competing products, such as statistical capabilities like error bar support on graphs, and polynomial regression analysis, however, many of these calculations can be performed by manually entering the functions and relationships plus a few macros. Another FOSS application called Gnumeric provides easier access to these statistical analysis features by presenting them to users with a wizard.
DataPilot
The feature DataPilot provides similar functionality to that of Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis. Unlike Excel, however, OpenOffice.org does not support Pivot charts.
With OpenOffice.org 2.0, the DataPilot feature has added support of Page fields - you can sort data on their fields.
Criticism
OpenOffice.org Calc has been criticized for:
- When editing a date, the date is displayed in the user's locale default date format irrespective of the user's system setting. Users can enter ISO 8601 dates, but may only edit them in another format. [15]
- Calc can be slow loading or saving very large spreadsheets (more than 20,000 rows and 100 columns) and can be 100 times slower than Excel.[16] This is in part due to the XML format for handling cell entries. A Novell Linux and GNOME hacker, Federico Mena, has analyzed the cause of the slowdown at his blog and offered some suggestions to improve the situation.[17] This is not considered a critical issue[citation needed] since many users dealing with large datasets will use a database program such as MySQL or PostgreSQL. The OpenOffice.org Base module can be used to connect to external databases. Further work on improving Calc performance is currently being conducted by other OpenOffice.org developers.[18]
In comparison to Microsoft Excel
See also the Comparison of spreadsheets article.
| This article's tone or style may not be appropriate for Wikipedia. Specific concerns may be found on the talk page. See Wikipedia's guide to writing better articles for suggestions. (June 2009) |
- Calc (as with the rest of the OpenOffice.org office suite) can export sheets (including charts) as PDF files from its 1.1.0 version, released in March 2004. In contrast, Microsoft Excel has only included that feature in its 2007 version.
- Another advantage of Calc over Excel is that it directly uses metrics when defining the width of a cell or column, or the height of a cell or row. This number can be expressed in either cm, mm, inches, picas or points.
- Calc also has some additional functions, like EASTERSUNDAY, which works for nearly any given year. Other ones, like DAYS and YEARS (which calculate date differences) can be replaced by the relatively unknown and virtually undocumented Excel DATEDIF.
- Nevertheless, although Calc fully supports the conditional formatting of Excel 97-2003, it neither supports the changes implemented in the 2007 version of Microsoft's software, nor the "data bars" that can be associated to specific cells.
- Unlike Microsoft's product (even Excel 2007), Calc offers a more sophisticated function wizard, that lets the user navigate through nested formulas. This feature is particularly useful when working with some complex sheets, to debug nested functions.
- Although Calc offers a feature similar to Excel's PivotTables (called DataPilot), it doesn't have an equivalent for PivotCharts, which somehow limits the possibility to share spreadsheets between these applications when used for data analysis.
- OpenOffice also allows users to save files in the .dbf (the old dBASE database file) format, support for which has been removed from Excel 2007. Although the .dbf is a legacy format, some programs (e.g. ESRI's ArcGIS) use the .dbf as the basis for handling all spreadsheet data. OpenOffice allows you to directly edit and save changes to GIS spreadsheet files, while Excel only offers import of .dbf files to be saved in a different format.
- Finally, with relation to macros, Calc's BASIC functions are basically like the ones of its competitor, although it lacks very few of them, like InStrRev (which reversely looks up a substring within a string). But unfortunately, Calc's object model is rather different from Excel's, and it doesn't support the easy-editing feature of Microsoft's product, via the object.property or object.procedure (object.method) "smart" characteristic (inherited from the Visual Studio programming environment).
See also
| Free software portal |
References
- ^ File formats OOo can open, December 1, 2008 [1]
- ^ "What's the maximum number of rows and cells for a spreadsheet file?". OpenOffice.org FAQ. http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F. Retrieved on 2008-11-04.
- ^ "Calc/hacks/number of rows - OpenOffice.org Wiki". http://wiki.services.openoffice.org/wiki/Calc/hacks/number_of_rows. Retrieved on 2008-06-03.
- ^ "OpenOffice.org 3.0's new features, an early look - OpenOffice.org Ninja". http://www.oooninja.com/2008/03/openofficeorg-30-new-features.html. Retrieved on 2008-06-03.
- ^ "What is the maximum number of cells in an OpenOffice.org spreadsheet?". OpenOffice.org FAQ. http://documentation.openoffice.org/faqs/spreadsheet/023.html. Retrieved on 2008-04-10.
- ^ a b Can be set at compile time"GNOME Office / Gnumeric - Frequently Asked Questions". http://www.gnome.org/projects/gnumeric/faq.shtml#5. Retrieved on 2008-06-03.
- ^ "Limitations of 1-2-3 for Windows". IBM.com. http://www-1.ibm.com/support/docview.wss?uid=swg27003548. Retrieved on 2008-04-10.
- ^ "Excel specifications and limits". http://office.microsoft.com/en-us/excel/HP051992911033.aspx. Retrieved on 2008-05-03.
- ^ "The "Big Grid" and Increased Limits in Excel 2007". Microsoft.com. http://msdn2.microsoft.com/en-us/library/aa730921.aspx. Retrieved on 2008-04-10.
- ^ "Excel specifications and limits". http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033. Retrieved on 2008-07-08.
- ^ "What's the maximum number of rows and cells for a spreadsheet file?". OpenOffice.org Calc FAQ. http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F. Retrieved on 2008-11-04.
- ^ "OpenOffice.org 3.0 New Features". OpenOffice.org 3.0 Features. http://www.openoffice.org/dev_docs/features/3.0/#1024_Columns_Per_Calc_Sheet_.28Instead_of_256.29. Retrieved on 2008-11-13.
- ^ "Can I use a spreadsheet file with more than 32,000 rows?". OpenOffice.org FAQ. http://documentation.openoffice.org/faqs/spreadsheet/034.html. Retrieved on 2008-04-29.
- ^ "What is the maximum number of cells in an OpenOffice.org spreadsheet?". OpenOffice.org FAQ. http://documentation.openoffice.org/faqs/spreadsheet/023.html. Retrieved on 2008-04-10.
- ^ Issue 5556: Date format is not consistent, for ISO 8601 input a corresponding cell format should be applied and input line should match
- ^ » Performance analysis of OpenOffice and MS Office | George Ou | ZDNet.com
- ^ Federico Mena Quintero - October 2005 Activity Log
- ^ Calc/To-Dos/Performance/misc - OpenOffice.org Wiki
External links
| Wikimedia Commons has media related to: OpenOffice.org Calc |
- Calc information page
- OpenOffice.org Spreadsheet Project
- Spreadsheet FAQ
- Official OpenOffice Documentation Wiki. Select any of the Calc sections
- Free lessons for OpenOffice.org Calc
|
||||||||||||||
|
|||||
Categories: OpenOffice.org | Free spreadsheet software | Spreadsheet software | Free cross-platform software
|
