OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 411)

Syntax Description

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 function returns

a logical or numerical value. Reference contains

the address of the cell in which the error occurs.

HLOOKUP(search_criteria;

array; index; sorted)

Searches for a value and reference to the cells

below the selected area. This function verifies if the

first row of an array contains a certain value. The

function returns the value in a row of the array,

named in the index, in the same column. The

search supports regular expressions.

HYPERLINK(URL) or

HYPERLINK(URL; cell_text)

When a cell that contains the HYPERLINK function

is clicked, the hyperlink opens. URL specifies the

link target. The optional cell_text argument is the

text displayed in the cell. If the cell_text parameter

is not specified, the URL is displayed.

Appendix B Description of Functions 411

1 2 ... 406 407 408 409 410 411 412 413 414 415 416 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 411

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3