OpenOffice.org Calc
 | |
 Screenshot of OpenOffice.org Calc | |
| 開發者 | Oracle Corporation in association with the Open Source community |
|---|---|
| 当前版本 | 3.2.1（2010年6月4日） |
| 源代码库 | |
| 操作系统 | Cross-platform |
| 类型 | Spreadsheet |
| 许可协议 | GNU Lesser General Public License |
| 网站 | www.openoffice.org |
OpenOffice.org 試算表是OpenOffice.org生產力軟體的項目之一。
OpenOffice.org 試算表是以GNU發布， 為自由軟體，使用者可以免費下載，或自由散布。
OpenOffice.org 試算表是與Microsoft Excel功能相當的試算表軟體，並可以開啟或儲存為Microsoft Excel的檔案格式。並提供了一些Excel沒有的功能，此外也可以把已完成之檔案存成 PDF檔。
OpenOffice.org 試算表通常會預設以 OpenDocument Format (ODF)的格式儲存。但也支援 CSV, HTML, SXC, DBF, DIF, UOF, SLK, SDC 等格式。[1]
與其他Openoffice.org檔案一樣，「OpenOffice.org 試算表」可跨平台運行。包含 Mac OS X, Microsoft Windows, Linux, FreeBSD和Solaris等作業系統。
特色
- 開放原始碼
- 可於多平台執行，包含：Windows, MacOS, Linux, Unix等等。
- 可存為多種格式ODF, Excel (XLS), CSV等格式。
- 可正確處理許多1900年前的文獻(許多試算表軟體，包含Excel，有1900 bug，所以無法處理1900年1月1日前的文獻)。
- 支援很大數量的方程，包含虛數和一些經濟上或統計上會用到的方程。
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.
 | 模板参数错误！（代码36）
|
- 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.
- Calc (unlike Excel) can use Python, JavaScript, C++ and CLI as additional macro languages.
See also
References
- ^ File formats OOo can open, December 1, 2008
- ^ 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
- ^ http://office.microsoft.com/en-us/help/HA011609811033.aspx
- ^ CalcLink Lauschke Consulting
- ^ DDFLink Lauschke Consulting
- ^ Installing Microsoft Excel's Solver. University of South Carolina.
External links
