Calc Guide

Syntax Description
LOWER(text) Converts all uppercase letters in a text string to
lowercase. Text is the text to be converted.
MID(text; start; number) Returns a text segment of a character string. The
parameters specify the starting position and the
number of characters. Text is the text containing the
characters to extract. Start is the position of the first
character in the text to extract. Number is the
number of characters in the part of the text.
PROPER(text) Capitalizes the first letter in all words of a text string.
Text is the text to be converted.
REPLACE(text; position;
length; new_text)
Replaces part of a text string with a different text
string. This function can be used to replace both
characters and numbers (which are automatically
converted to text). The result of the function is always
displayed as text. To perform further calculations with
a number which has been replaced by text, convert it
back to a number using the VALUE function. Any text
containing numbers must be enclosed in quotation
marks so it is not interpreted as a number and
automatically converted to text. Text is text of which
a part will be replaced. Position is the position within
the text where the replacement will begin. Length is
the number of characters in text to be replaced.
New_text is the text which replaces text..
REPT(text; number)
Repeats a character string by the given number of
copies. Text is the text to be 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.
416 OpenOffice.org 3.3 Calc Guide