Calc Guide

Syntax Description
VLOOKUP(search_criterion;
array; index; sort_order)
Searches vertically with reference to adjacent cells
to the right. If a specific value is contained in the
first column of an array, returns the value to the
same line of a specific array column named by
index. The search supports regular expressions.
Search_criterion is the value searched for in the
first column of the array. Array is the reference,
which must include at least two columns. Index is
the number of the column in the array that
contains the value to be returned. The first column
has the number 1. 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.
414 OpenOffice.org 3.3 Calc Guide