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日前的文獻)。
- 支援很大數量的方程,包含虛數和一些經濟上或統計上會用到的方程。
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]
參見
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
External links
