Calc Guide

Syntax Description
TRANSPOSE(array) Transposes the rows and columns of an array.
Array is the array in the spreadsheet that is to be
transposed.
TREND(data_Y;
data_X; new_data_X;
linear_Type)
Returns values along a linear trend. Data_Y is the
Y Data array. Data_X (optional) is the X Data
array. New_data_X (optional) is the array of the X
data, which are used for recalculating values.
Linear_type is optional. If linear_type = 0, then
lines will be calculated through the zero point.
Otherwise, offset lines will also be calculated. The
default is linear_type <> 0.
Spreadsheet functions
Use spreadsheet functions to search and address cell ranges and
provide feedback regarding the contents of a cell or range of cells. You
can use functions such as HYPERLINK() and DDE() to connect to other
documents or data sources.
Table 43: Spreadsheet functions
Syntax Description
ADDRESS(row; column;
abs; sheet)
Returns a cell address (reference) as text,
according to the specified row and column
numbers. Optionally, whether the address is
interpreted as an absolute address (for
example, $A$1) or as a relative address (as
A1) or in a mixed form (A$1 or $A1) can be
determined. The name of the sheet can also
be specified. Row is the row number for the
cell reference. Column is the column number
for the cell reference (the number, not the
letter). Abs determines the type of reference.
Sheet is the name of the sheet.
AREAS(reference) Returns the number of individual ranges that
belong to a multiple range. A range can
consist of contiguous cells or a single cell.
Reference is the reference to a cell or cell
range.
CHOOSE(index; value1; ...
value30)
Uses an index to return a value from a list of
up to 30 values. Index is a reference or
number between 1 and 30 indicating which
value is to be taken from the list. Value1; ...
470 OpenOffice.org 3.x Calc Guide