跳转到内容

OpenOffice.org Calc

维基百科，自由的百科全书

这是本页的一个历史版本，由Ugn​（留言 | 贡献）在2010年11月10日 (三) 11:18编辑。这可能和当前版本存在着巨大的差异。

OpenOffice.org Calc
Screenshot of OpenOffice.org Calc
開發者Oracle Corporation in association with the Open Source community
当前版本3.2.1（2010年6月4日，​15年前​（2010-06-04））
源代码库
編輯維基數據鏈接
操作系统Cross-platform
类型Spreadsheet
许可协议GNU Lesser General Public License
网站www.openoffice.org
OpenOffice.org Calc running on Mac OS X

OpenOffice.org 試算表是OpenOffice.org生產力軟體的項目之一。

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.

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 a 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 in the past been criticized for the following:

  • 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.[2]
  • 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.[3] 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.[4] Further work on improving Calc performance is currently being conducted by other OpenOffice.org developers.[5]

In comparison to Microsoft Excel

See also the Comparison of spreadsheets article.

  • 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 from 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 most years. Other ones, like DAYS and YEARS (which calculate date differences) can be replaced by Excel's DATEDIF function[6].
    • Calc fully supports the conditional formatting of Excel 97-2003, but it supports neither the changes implemented from the 2007 version of Microsoft's software, nor the "data bars" that can be associated to specific cells.
    • Unlike Microsoft's product (even Excel 2010), 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.
    • It is possible in Calc to undo the "Delete Sheet" operation, which Excel is incapable of.
    • Although Calc offers a feature similar to Excel's PivotTables (called DataPilot), it doesn't have an equivalent for PivotCharts, which somewhat 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.
    • Calc does not have enough horizontal columns to store more than about 3.9 years of stock prices or any other daily information, if you want to use one column per data point.
    • Calc does not have any add-ins for real-time stock quotes. However, live streaming financial data can be provided with two commercial packages for Mathematica, CalcLink[7] and DDFLink[8].
    • Calc did not have the "Solver" add-in until version 3.0, while Excel has had this since Office 97 as an add-in[9] or perhaps earlier.
    • 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). Calc's object model however, 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).
    • Calc doesn't have XLM macros that are embedded in Excel.

    See also

    References

    1. ^ File formats OOo can open, December 1, 2008
    2. ^ Issue 5556: Date format is not consistent, for ISO 8601 input a corresponding cell format should be applied and input line should match
    3. ^ » Performance analysis of OpenOffice and MS Office | George Ou | ZDNet.com
    4. ^ Federico Mena Quintero - October 2005 Activity Log
    5. ^ Calc/To-Dos/Performance/misc - OpenOffice.org Wiki
    6. ^ http://office.microsoft.com/en-us/help/HA011609811033.aspx
    7. ^ CalcLink Lauschke Consulting
    8. ^ DDFLink Lauschke Consulting
    9. ^ Installing Microsoft Excel's Solver. University of South Carolina. 
    维基共享资源上的相关多媒体资源：OpenOffice.org Calc

    Template:Spreadsheets

    检索自“https://zh.wikipedia.org/w/index.php?title=OpenOffice.org_Calc&oldid=14886242”