Documentation/Calc Functions/CELL

Function name:
CELL

Category:
Information

Summary:
Provides requested information on location, formatting properties, or contents of a cell.

Syntax:
CELL(Info Type[; Reference])

Returns:
Returns a value whose type depends on the nature of the information requested.

Arguments:
Info Type is a text string, or a reference to a cell containing a text string, that determines the type of information to be returned. Info Type is case-insensitive and must correspond to one of the following permitted options – "ADDRESS", "COL", "COLOR", "CONTENTS", "COORD", "FILENAME", "FORMAT", "PARENTHESES", "PREFIX", "PROTECT", "ROW", "SHEET", "TYPE", or "WIDTH". More detail about each of these options is given in the table below.

Reference is a reference to the cell for which information is to be returned. If Reference is omitted, information is returned for the cell in which the formula is located. Reference may be any of the following:


 * A reference to a single cell.
 * A reference to a cell range (for example, D6:E12).
 * The name of a named range.
 * The name of a database range.

Where Reference specifies multiple cells, CELL returns information for the top left of those cells.


 * If Info Type does not correspond to one of the expected strings, then CELL reports an invalid argument error (Err:502).
 * If Reference does not correspond to a valid reference, the CELL reports a #REF! error.
 * If Info Type is set to “CONTENTS” and Reference is omitted, then CELL reports a circular reference error (Err:522).

Additional details:
None

Examples:
See examples within the tables in the section above.

Related LibreOffice functions:
None.

ODF standard:
Section 6.13.3, part 2

Equivalent Excel functions:
CELL