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

100

101

Syntax Description

Sort_order (optional) indicates whether the

first column in the array is sorted in

ascending order.

Text functions

Use Calc’s text functions to search and manipulate text strings or

character codes.

Table 44: Text functions

Syntax Description

ARABIC(text) Calculates the value of a Roman number. The

value range must be between 0 and 3999. Text

is the text that represents a Roman number.

BASE(number; radix;

[minimum_length])

Converts a positive integer to a specified base

then into text using the characters from the

base's numbering system (decimal, binary,

hexadecimal, etc.). Only the digits 0-9 and the

letters A-Z are used. Number is the positive

integer to be converted. Radix is the base of

the number system. It may be any positive

integer between 2 and 36. Minimum_length

(optional) is the minimum length of the

character sequence that has been created. If

the text is shorter than the indicated minimum

length, zeros are added to the left of the string.

CHAR(number) Converts a number into a character according

to the current code table. The number can be a

two-digit or three-digit integer number.

Number is a number between 1 and 255

representing the code value for the character.

CLEAN(text) Removes all non-printing characters from the

string. Text refers to the text from which to

remove all non-printable characters.

CODE(text) Returns a numeric code for the first character

in a text string. Text is the text for which the

code of the first character is to be found.

CONCATENATE(text_1;

text_2; ...; text_30)

Combines several text strings into one string.

Text_1; text_2; ... text_30 are text passages

that are to be combined into one string.

Appendix B Description of Functions 475

1 2 ... 470 471 472 473 474 475 476 477 478 479 480 ... 496 497

Commentaires sur ces manuels

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 475

Commentaires sur ces manuels

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