Calc Guide

Syntax Description
value30 is the list of values entered as a
reference to a cell or as individual values.
COLUMN(reference) Returns the column number of a cell
reference. If the reference is a cell, the
column number of the cell is returned; if the
parameter is a cell area, the corresponding
column numbers are returned in a single-row
array if the formula is entered as an array
formula. If the COLUMN function with an
area reference parameter is not used for an
array formula, only the column number of
the first cell within the area is determined.
Reference is the reference to a cell or cell
area whose first column number is to be
found. If no reference is entered, the column
number of the cell in which the formula is
entered is found. Calc automatically sets the
reference to the current cell.
COLUMNS(array) Returns the number of columns in the given
reference. Array is the reference to a cell
range whose total number of columns is to be
found. The argument can also be a single
cell.
DDE(server; file; range;
mode)
Returns the result of a DDE-based link. If the
contents of the linked range or section
changes, the returned value will also change.
The spreadsheet can be reloaded, or Edit >
Links selected, to see the updated links.
Cross-platform links, for example from an
OpenOffice.org installation running on a
Windows machine to a document created on
a Linux machine, are not supported. Server
is the name of a server application.
OpenOffice.org applications have the server
name “Soffice”. File is the complete file
name, including path. Range is the area
containing the data to be evaluated. Mode is
an optional parameter that controls the
method by which the DDE server converts its
data into numbers.
ERRORTYPE(reference) Returns the number corresponding to an
error value occurring in a different cell. With
the aid of this number, an error message text
can be generated. If an error occurs, the
Appendix B Description of Functions 471