Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Add-in functions

You can extend Calc’s features with Add-ins programmed to be compatible with OOo's Application Programming Interface (API). Add-ins are either Dynamically Linked Libraries (*.dll) or shared libraries (such as Shared Object libraries, *.so), depending on the operating system under which OOo is running. When placed in the directory (or folder) defined in Tools > Options > OpenOffice.org > Paths > Add-ins dialog, these libraries are recognized and can be utilized by Calc.Installing a function Add-in library makes its functions available through the Function Wizard(Insert > Functionor Ctrl+F2) and the Function List(Insert > Function List).

OOo provides samples of the add-in interface of Calc which can be selectively installed or uninstalled through the OOo Setup program.These add-ins are listed in the following table.If these add-ins are not installed, neither the following described functions, nor the functions marked with a * in the previous lists, will be available.

More detailed information on programming add-ins for OpenOffice.org can be found in the OpenOffice.org Developer's Guide or on the OOo developers’ website: http://development.openoffice.org/.

Table 21: Add-in functions

Syntax

Description

*BESSELI(x; n)

Calculates the modified Bessel function In(x). x is the value on which the function will be calculated. n is the order of the Bessel function

*BESSELJ(x; n)

Calculates the Bessel function Jn(x) (cylinder function). x is the value on which the function will be calculated. n is the order of the Bessel function

*BESSELK(x; n)

Calculates the modified Bessel function Kn(x). x is the value on which the function will be calculated. n is the order of the Bessel function

*BESSELY(x; n)

Calculates the modified Bessel function Yn(x), also known as the Weber or Neumann function. x is the value on which the function will be calculated. n is the order of the Bessel function

*BIN2DEC(number)

Returns the decimal number for the binary number entered. Number is the binary number.

*BIN2HEX(number; places)

Returns the hexadecimal number for the binary number entered. Number is the binary number. Places is the number of places to be output.

*BIN2OCT(number; places)

Returns the octal number for the binary number entered. Number is the binary number. Places is the number of places to be output.

*COMPLEX(real_num; i_num; suffix)

Returns a complex number from a real coefficient and an imaginary coefficient. Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is list of options, "i†or "jâ€.

*CONVERT_ADD(number; from_unit; to_unit)

Converts a value from one unit of measure to the corresponding value in another unit of measure. Number is the number to be converted. From_unit is the unit from which conversion is taking place. To_unit is the unit to which conversion is taking place.

*DEC2BIN(number; places)

Returns the binary number for the decimal number entered between -512 and 511. Number is the decimal number. Places is the number of places to be output.

*DEC2HEX(number; places)

Returns the hexadecimal number for the decimal number entered. Number is the decimal number. Places is the number of places to be output.

*DEC2OCT(number; places)

Returns the octal number for the decimal number entered. Number is the decimal number. Places is the number of places to be output.

*DELTA(number_1; number_2)

Returns TRUE (1) if both numbers are equal, otherwise returns FALSE (0).

*ERF(lower_limit; upper_limit)

Returns values of the Gaussian error integral. Lower_limit is the lower limit of integral. Upper_limit (optional) is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit.

*ERFC(lower_limit)

Returns complementary values of the Gaussian error integral between x and infinity. Lower limit is the lower limit of integral (x).

*FACTDOUBLE(number)

Returns the factorial of the number with increments of 2. If the number is even, the following factorial is calculated: n*(N-2)*(n-4)*...*4*2. If the number is uneven, the following factorial is calculated: n*(N-2)*(n-4)*...*3*1.

*GESTEP(number; step)

Returns 1 if Number is greater than or equal to Step.

*HEX2BIN(number; places)

Returns the binary number for the hexadecimal number entered. Number is the hexadecimal number. Places is the number of places to be output.

*HEX2DEC(number)

Returns the decimal number for the hexadecimal number entered. Number is the hexadecimal number.

*HEX2OCT(number; places)

Returns the octal number for the hexadecimal number entered. Number is the hexadecimal number. Places is the number of places to be output.

*IMABS(complex_number)

Returns the absolute value (modulus) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMAGINARY(complex _number)

Returns the imaginary coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMARGUMENT(complex _number)

Returns the argument (the phi angle) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMCONJUGATE(complex _number)

Returns the conjugated complex complement to a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMCOS(complex_number)

Returns the cosine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMDIV(numerator; denominator)

Returns the division of two complex numbers. Numerator, Denominator are entered in the form "x + yi" or "x + yj"

*IMEXP(complex_number)

Returns the power of e (the Eulerian number) and the complex number. The complex_number is entered in the form "x + yi" or "x + yj"

*IMLN(complex_number)

Returns the natural logarithm of a complex_number. The complex_number is entered in the form "x + yi" or "x + yjâ€

*IMLOG10(complex _number)

Returns the common logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMLOG2(complex _number)

Returns the binary logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMPOWER(complex _number; number)

Returns the integer power of a complex_number. The complex number is entered in the form "x + yi" or "x + yj". Number is the exponent.

*IMPRODUCT(complex _number; complex_number_1; ...)

Returns the product of up to 29 complex_numbers. The complex numbers are entered in the form "x + yi" or "x + yj"

*IMREAL(complex _number)

Returns the real coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMSIN(complex_number)

Returns the sine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"

*IMSQRT(complex_number)

Returns the square root of a complex_number. The complex numbers are entered in the form "x + yi" or "x + yj"

*IMSUB(complex_number_1; complex_number_2)

Returns the subtraction of two complex_numbers. The complex_numbers are entered in the form "x + yi" or "x + yj"

*IMSUM(complex_number; complex_number_1; ...)

Returns the sum of up to 29 complex numbers. The complex_numbers are entered in the form "x + yi" or "x + yj"

*OCT2BIN(number; places)

Returns the binary number for the octal number entered. Number is the octal number. Places is the number of places to be output.

*OCT2DEC(number)

Returns the decimal number for the octal number entered. Number is the octal number.

*OCT2HEX(number; places)

Returns the hexadecimal number for the octal number entered. Number is the octal number. Places is the number of places to be output.








OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire