The OpenOffice Calc is the spreadsheet application of the OpenOffice productivity suite, and is analogous to Microsoft Office’s Excel and the Lotus 1-2-3, the first of its kind; the OpenOffice Calc has comparable features and capabilities. Open Office keeps crashing for a few months now. Both calc and writer crash. In writer it usually happens when I edit the document when a table start on a page and end on another. I have completly format my PC, but after reinstallation the problem came up again.
| < Previous Section | Next Section > |
Open Office Calc Countif
| < Previous Page | Next Page > |
Evernote web clipper for edge browser.
List of Calc Mathematical functions
| Trigonometric | |
| COS | Returns the cosine of an angle. |
| SIN | Returns the sine of an angle. |
| TAN | Returns the tangent of an angle. |
| COT | Returns the cotangent of an angle. |
| ACOS | Returns the inverse cosine of a number. |
| ACOT | Returns the inverse cotangent of a number. |
| ASIN | Returns the inverse sine of a number. |
| ATAN | Returns the inverse tangent of a number. |
| ATAN2 | Returns the inverse tangent for specified x and y coordinates. |
| DEGREES | Converts radians into degrees. |
| RADIANS | Converts degrees into radians. |
| PI | Returns the value of PI. |
| Hyperbolic | |
| COSH | Returns the hyperbolic cosine of an angle. |
| SINH | Returns the hyperbolic sine of an angle. |
| TANH | Returns the hyperbolic tangent of an angle. |
| COTH | Returns the hyperbolic cotangent of a given number (angle). |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOTH | Returns the inverse hyperbolic cotangent of the given number. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| Rounding and remainders | |
| TRUNC | Truncates a number by removing decimal places. |
| ROUND | Rounds a number to a certain precision. |
| ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |
| ROUNDUP | Rounds a number up, away from zero, to a certain precision. |
| CEILING | Returns a number rounded up to a multiple of another number. |
| FLOOR | Rounds a number down to the nearest multiple of another number. |
| EVEN | Rounds a number to the next even integer away from zero. |
| ODD | Rounds a number up to the next highest odd integer. |
| MROUND | Returns a number rounded to the nearest multiple of another number. |
| INT | Rounds a number down to the nearest integer. |
| QUOTIENT | Returns the integer result of a division operation. |
| MOD | Returns the remainder when one integer is divided by another. |
| Logarithm / powers | |
| EXP | Returns e raised to the power of a number. |
| POWER | Returns a number raised to a power. |
| LOG | Returns the natural logarithm of a number. |
| LN | Returns the logarithm of a number to the specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| Bessel functions | |
| BESSELI | Calculates the modified Bessel function of the first kind. |
| BESSELJ | Calculates the Bessel function of the first kind. |
| BESSELK | Calculates the modified Bessel function of the second kind. |
| BESSELY | Calculates the Bessel function of the second kind (the Neumann or Weber function). |
| Miscellaneous | |
| ABS | Returns the absolute value of a number. |
| COMBIN | Returns the number of combinations of a subset of items. |
| COMBINA | Returns the number of ordered combinations of a subset of items. |
| CONVERT | Converts between legacy European currencies and Euros. |
| CONVERT_ADD | Converts a number from one measurement system to another. |
| COUNTBLANK | Returns the number of empty cells. |
| COUNTIF | Counts the number of cells in a range that meet a specified condition. |
| DELTA | Returns 1 if two numbers are equal, and 0 otherwise. |
| ERF | Calculates the error function (Gauss error function). |
| ERFC | Calculates the complementary error function (complementary Gauss error function). |
| FACT | Returns the factorial of a number, n!. |
| FACTDOUBLE | Returns the double factorial of a number, n!!. |
| GCD | Returns the greatest common divisor of two or more integers. |
| GCD_ADD | Returns the greatest common divisor of a list of numbers. |
| GESTEP | Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. |
| ISEVEN | Returns TRUE if the value is an even number. |
| ISODD | Returns TRUE if the value is an odd number. |
| LCM | Returns the least common multiple of one or more integers. |
| LCM_ADD | Returns the lowest common multiple of a list of numbers. |
| MULTINOMIAL | Returns the factorial of the sum divided by the product of the factorials. |
| PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
| RAND | Returns a random number between 0 and 1. |
| RANDBETWEEN | Returns an integer random number in a specified range. |
| SERIESSUM | Sums the first terms of a power series. |
| SIGN | Returns the sign of a number. |
| SQRT | Returns the positive square root of a number. |
| SQRTPI | Returns the square root of (PI times a number). |
| SUBTOTAL | Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. |
| SUM | Sums the contents of cells. |
| SUMIF | Conditionally sums the contents of cells in a range. |
| SUMSQ | Returns the sum of the squares of numbers. |
- Functions listed alphabetically,
| 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. Hyon gak sunim. 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: Realflight dongle emulator.
- 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.
Open Office Calc Download
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 Remove Duplicates