Документ взят из кэша поисковой машины. Адрес оригинального документа : http://uneex.mithril.cs.msu.su/static/GnumericDoc_ru/r1857.html
Дата изменения: Mon Sep 26 12:35:55 2011
Дата индексирования: Mon Oct 1 22:42:10 2012
Кодировка: UTF-8
CELL

CELL

Name

CELL -- 

Synopsis

CELL(type,ref)

Description

CELL returns information about the formatting, location, or contents of a cell.

@type specifies the type of information you want to obtain:

address Returns the given cell reference as text.

col Returns the number of the column in @ref.

contents Returns the contents of the cell in @ref.

format Returns the code of the format of the cell.

parentheses Returns 1 if @ref contains a negative value

and it's format displays it with parentheses.

row Returns the number of the row in @ref.

width Returns the column width.

This function is Excel compatible.

Examples

CEll("format",A1) returns the code of the format of the cell A1.

See also