OpenOffice is the leading open-source office suite for word processing, spreadsheets, databases, graphics, presentations and more. It is the first and only application suite that can be seriously considered as a substitute for the massive power and flexibility of Microsoft Office. Modul Open Office Calc 1. 2011 MODUL APLIKASI PENGOLAH ANGKA (OPEN OFFICE CALC) DASAR OpenOffice.org Calc mempunyai kegunaan yang sama dengan Microsoft Excel dimana OpenOffice.org Calc berguna untuk membuat file spreadsheet. This is a checkbook register form that you can use to record and monitor your daily expenses. It consist of 2 worksheets. The first worksheet is a checkbook worksheet where you.
| Developer(s) | StarOffice StarDivision (1984–1999) OpenOffice.org Sun Microsystems (1999–2010) Oracle Corporation (2010–2011) Apache OpenOffice Apache Software Foundation (2011—) |
|---|---|
| Repository | |
| Operating system | Microsoft Windows, Mac OS X, Linux |
| Type | Spreadsheet |
| License | LGPL version 3[1] (OpenOffice.org 2 Beta 2 and earlier are dual-licensed under the SISSL and LGPL)[2] Apache License 2.0 (Apache OpenOffice 3.4 and later)[3] |
| Website | www.openoffice.org/product/calc.html |
OpenOffice Calc is the spreadsheet part of the OpenOffice software package.
Calc is similar to Microsoft Excel, with almost the same abilities. Calc is capable of opening and saving spreadsheets in Microsoft Excel's file format. 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 also capable of writing spreadsheets directly as PDF 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). Calc also supports a wide range of other file formats, for both opening and saving files.
Just like the entire OpenOffice package, Calc can be used on many operating systems, including Mac OS X, Microsoft Windows, Linux, FreeBSD and Solaris. Available under the Apache License, Calc is free software.
Specifications[change | change source]
Calc can store a maximum of 65,536 rows with 1024 columns in each sheet, with a maximum of 256 sheets.[4] 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.[5]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.[6]Prior to V2.0, the limit on the number of rows was 32,000.[7]
| Program | Rows (per sheet) | Columns (per sheet) | Total Cells (per sheet) | Sheets |
|---|---|---|---|---|
| OpenOffice.org Calc 3[4][8] | 1,048,576 | 1024 | 1,073,741,824 | 256 |
| OpenOffice.org Calc 2[6][7] | 65,536 | 256 | 16,777,216 | 256 |
| Microsoft Excel 2003 | 65,536 | 256 | 16,777,216 | Available Memory[9] |
| Microsoft Excel 2007[10] | 1,048,576 | 16,384 | 17,179,869,184 | Available Memory [11] |
| Gnumeric | 16,777,216[12] | 16,384[12] | 274,877,906,944 | Available memory[13] |
| KSpread | 32,767 | 32,767 | 1,073,676,289 | ? |
| Lotus 1-2-3[14] | 65,536 | 256 | 16,777,216 | 256 |
| LibreOffice spreadsheet[15] | 1,048,576 | 1024 | 1,073,741,824 | 10,000 |
Special abilities[change | change source]
Abilities of Calc include:
- Available on many operating systems, including Microsoft Windows,Mac OS X, Linux, Unix, etc.
- Ability to read/write OpenDocument, Excel .xls, CSV, and several other file formats.
- Able to handle dates on or before 1900 correctly (many spreadsheet applications, including Microsoft 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 statistical functions.
Missing features[change | change source]
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. Another FOSS application called Gnumeric provides easier access to these statistical analysis features by showing them to users with a wizard.
References[change | change source]
- ↑'LGPL v3'. Oracle Corporation. Retrieved 22 April 2009.CS1 maint: discouraged parameter (link)
- ↑'License Simplification FAQ'. Oracle Corporation. Retrieved 27 February 2010.CS1 maint: discouraged parameter (link)
- ↑'Licenses & Copyrights'. Apache Software Foundation. Retrieved 2 January 2012.CS1 maint: discouraged parameter (link)
- ↑ 4.04.1'What's the maximum number of rows and cells for a spreadsheet file?'. OpenOffice.org FAQ. Archived from the original on 2009-05-04. Retrieved 2008-11-04.CS1 maint: discouraged parameter (link)Cite error: Invalid
<ref>tag; name 'ooo3-max_cells' defined multiple times with different content - ↑'Calc/hacks/number of rows - OpenOffice.org Wiki'. Retrieved 2008-06-03.CS1 maint: discouraged parameter (link)
- ↑ 6.06.1'Can I use a spreadsheet file with more than 32,000 rows?'. OpenOffice.org FAQ. Retrieved 2008-04-29.CS1 maint: discouraged parameter (link)Cite error: Invalid
<ref>tag; name 'max_cells' defined multiple times with different content - ↑ 7.07.1'What is the maximum number of cells in an OpenOffice.org spreadsheet?'. OpenOffice.org FAQ. Retrieved 2008-04-10.CS1 maint: discouraged parameter (link)
- ↑'OpenOffice.org 3.0 New Features'. OpenOffice.org 3.0 Features. Retrieved 2008-11-10.External link in
|work=(help)CS1 maint: discouraged parameter (link) - ↑'Excel specifications and limits'. Retrieved 2008-05-03.CS1 maint: discouraged parameter (link)
- ↑'The 'Big Grid' and Increased Limits in Excel 2007'. Microsoft.com. Retrieved 2008-04-10.External link in
|work=(help)CS1 maint: discouraged parameter (link) - ↑'Excel specifications and limits'. Retrieved 2008-07-08.CS1 maint: discouraged parameter (link)
- ↑ 12.012.1'GNOME Help - Worksheet display'. Retrieved 2020-05-15.CS1 maint: discouraged parameter (link)
- ↑'Gnumeric Mailing List - Re: Maximum number of sheet, cell, and column'. Retrieved 2020-05-15.CS1 maint: discouraged parameter (link)
- ↑'Limitations of 1-2-3 for Windows'. IBM.com. Archived from the original on 2013-01-03. Retrieved 2008-04-10.External link in
|work=(help)CS1 maint: discouraged parameter (link) - ↑'Frequently asked questions - Calc'. The Document Foundation. Retrieved 2017-07-15.External link in
|work=(help)CS1 maint: discouraged parameter (link)
Other websites[change | change source]
Open Office Calc Formula
If you are looking for OpenOffice SpreadSheets, you have come to the right place. We explain what OpenOffice SpreadSheets is and point you to the official download.
What is OpenOffice SpreadSheets?
OpenOffice SpreadSheets is an application included in the OpenOffice Suite from The Apache Software Organization. The Suite also includes Writer, which is the word processing application of the software; Impress, the presentation application; Draw, a drawing utility; Math, an equation editor; and Base, a database management system for desktops.
The spreadsheets application of the software suite is known as Calc or OpenOffice Calc. A Calc spreadsheet is composed of API (Application Programming Interface) objects that allow for organized data inputs. API objects that can be utilized in a Calc spreadsheet include the following: Columns, Rows, SheetCell, SheetCellRange, and SheetShell Range Collections. Generally, a spreadsheet consists of a SheetCellRange and a series of sub-ranges.
Columns can be widened to accommodate length of data inputted, allowing for accurate display of complete data. Data alignment can be centered, left, right or justified; the options for which are all provided on the toolbar. Cells can likewise be merged, with the Merge Cells option provided in the Formatting toolbar icon.
The software allows for data importation created with other spreadsheet programs such as Microsoft Excel. OpenOffice SpreadSheets is a free application that can be downloaded from the Apache website.
Download OpenOffice SpreadSheets from the developer
File.org does not provide software hosting. We send you directly to the developer's site, to make sure you download the latest, original version of the program.
Open Office Calc Fit To Page
File types supported by OpenOffice SpreadSheets
Our users primarily use OpenOffice SpreadSheets to open these file types:
About file types supported by OpenOffice SpreadSheets
Open Office Calc Print Gridlines
File.org aims to be the go-to resource for file type- and related software information. We spend countless hours researching various file formats and software that can open, convert, create or otherwise work with those files.
Open Office Calc Tutorial
If you have additional information about which types of files OpenOffice SpreadSheets can process, please do get in touch - we would love hearing from you.