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

100

101

Syntax Description

repeated. Number is the number of

repetitions. The result can be a maximum of

255 characters.

RIGHT(text; number) Defines the last character or characters in a

text string. Text is the text of which the right

part is to be determined. Number (optional) is

the number of characters from the right part of

the text.

ROMAN(number; mode) Converts a number into a Roman numeral. The

value range must be between 0 and 3999; the

modes can be integers from 0 to 4. Number is

the number that is to be converted into a

Roman numeral. Mode (optional) indicates the

degree of simplification. The higher the value,

the greater is the simplification of the Roman

numeral.

ROT13(text) Encrypts a character string by moving the

characters 13 positions in the alphabet. After

the letter Z, the alphabet begins again

(Rotation). Applying the encryption function

again to the resulting code, decrypts the text.

Text: Enter the character string to be

encrypted. ROT13(ROT13(Text)) decrypts the

code.

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.

478 OpenOffice.org 3.x Calc Guide

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

Commentaires sur ces manuels

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 478

Commentaires sur ces manuels

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