OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 479)

100

101

Syntax Description

T(value) Converts a number to a blank text string.

Value is the value to be converted. Also, a

reference can be used as a parameter. If the

referenced cell includes a number or a formula

containing a numerical result, the result will be

an empty string.

TEXT(number; format) Converts a number into text according to a

given format. Number is the numerical value

to be converted. Format is the text which

defines the format. Use decimal and thousands

separators according to the language set in the

cell format.

TRIM(text) Removes spaces that are in front of a string, or

aligns cell contents to the left. Text is the text

in which leading spaces are removed, or the

cell in which the contents will be left-aligned.

UPPER(text)

Converts the string specified in the text

parameter to uppercase. Text is the lower case

letters you want to convert to upper case.

VALUE(text)

Converts a text string into a number. Text is

the text to be converted to a number.

Add-in functions

Table 45: 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

Appendix B Description of Functions 479

1 2 ... 474 475 476 477 478 479 480 481 482 483 484 ... 496 497

Commentaires sur ces manuels

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 479

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel OpenOffice.org OpenOffice - 3.2