Calc Guide

Syntax Description
SUMX2PY2(array_X;
array_Y)
Returns the sum of the sum of squares of corresponding
values in two arrays. Array_X is the first array whose
arguments are to be squared and added. Array_Y is the
second array, whose elements are to be added and
squared.
SUMXMY2(array_X;
array_Y)
Adds the squares of the variance between corresponding
values in two arrays. Array_X is the first array whose
elements are to be subtracted and squared. Array_Y is
the second array, whose elements are to be subtracted
and squared.
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; ... value30 is the list of values
entered as a reference to a cell or as individual
values.
410 OpenOffice.org 3.3 Calc Guide