Calc Guide

Syntax Description
used in an array formula, only the row
number of the first range cell will be
returned. Reference is a cell, an area, or the
name of an area. If a reference is not
indicated, Calc automatically sets the
reference to the current cell.
ROWS(array) Returns the number of rows in a reference or
array. Array is the reference or named area
whose total number of rows is to be
determined.
SHEET(reference) Returns the sheet number of a reference or a
string representing a sheet name. If no
parameters are entered, the result is the
sheet number of the spreadsheet containing
the formula. Reference (optional) is the
reference to a cell, an area, or a sheet name
string.
SHEETS(reference) Determines the number of sheets in a
reference. If no parameters are entered, the
result is the number of sheets in the current
document. Reference (optional) is the
reference to a sheet or an area.
STYLE(style; time; style2) Applies a style to the cell containing the
formula. After a set amount of time, another
style can be applied. This function always
returns the value 0, allowing it to be added
to another function without changing the
value. Style is the name of a cell style
assigned to the cell. Time is an optional time
range in seconds. Style2 is the optional
name of a cell style assigned to the cell after
a certain amount of time has passed.
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.
474 OpenOffice.org 3.x Calc Guide