OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 417)

Syntax Description

SEARCH(find_text; text;

position)

Returns the position of a text segment within a

character string. The start of the search can be set as

an option. The search text can be a number or any

sequence of characters. The search is not case-

sensitive. The search supports regular expressions.

Find_text is the text to be searched for. Text is the

text where the search will take place. Position

(optional) is the position in the text where the search

is to start.

SUBSTITUTE(text;

search_text; new text;

occurrence)

Substitutes new text for old text in a string. Text is

the text in which text segments are to be exchanged.

Search_text is the text segment that is to be

replaced (a number of times). New text is the text

that is to replace the text segment. Occurrence

(optional) indicates how many occurrences of the

search text are to be replaced. If this parameter is

missing, the search text is replaced throughout.

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.

Appendix B Description of Functions 417

1 2 ... 412 413 414 415 416 417 418 419 420 421 422 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 417

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3