Calc Guide

Syntax Description
OFFSET(reference; rows;
columns; height; width)
Returns the value of a cell offset by a certain
number of rows and columns from a given
reference point. Reference is the cell from which
the function searches for the new reference. Rows
is the number of cells by which the reference was
corrected up (negative value) or down. Columns is
the number of columns by which the reference was
corrected to the left (negative value) or to the
right. Height is the optional vertical height for an
area that starts at the new reference position.
Width is the optional horizontal width for an area
that starts at the new reference position.
ROW(reference)
Returns the row number of a cell reference. If the
reference is a cell, it returns the row number of the
cell. If the reference is a cell range, it returns the
corresponding row numbers in a one-column Array
if the formula is entered as an array formula. If the
ROW function with a range reference is not 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.
Appendix B Description of Functions 413