Manuals/calci/CELL

CELL(type,reference)

• $type$ specifies what type of information we want.
• $reference$ is the cell we want to retrieve information.

Description

• This function is used to retrieve information about a cell
• The information about the cell can be the contents,size, formatting etc.
• $type$ specifies what type of information we want.
• $reference$ is the cell we want to retrieve information.
• $reference$ is optional.
• If $reference$ is omitted, the last cell that was changed will be taken

Type	Value Returned
"address"	Address of the cell. If the cell refers to a range, it is the first cell in the range.
"col"	Column number of the cell.
"color"	Returns 1 if the color is a negative value; Otherwise it returns 0.
"contents"	Contents of the upper-left cell.
"filename"	Filename of the file that contains reference.
"format"	Number format of the cell. See example formats below.
"parentheses"	Returns 1 if the cell is formatted with parentheses; Otherwise, it returns 0.
"prefix"	Label prefix for the cell. Returns a single quote (') if the cell is left-aligned. Returns a double quote (") if the cell is right-aligned. Returns a caret (^) if the cell is center-aligned. Returns a back slash (\) if the cell is fill-aligned. Returns an empty text value for all others
"protect"	Returns 1 if the cell is locked. Returns 0 if the cell is not locked.
"row"	Row number of the cell.
"type"	Returns "b" if the cell is empty. Returns "l" if the cell contains a text constant. Returns "v" for all others
"width"	Column width of the cell, rounded to the nearest integer.

Examples

Spreadsheet

	A	B	C	D	E
1	2	3	7	9	15
2	8	12	13	20	25
3	14	3	9	6	15

• =CELL("address",A2) :
• =CELL("col",A2) : 1
• =CELL("row",A2) : 2
• =CELL("type",A3) : v
• =CELL("width",A3):102

See Also

• COLUMN
• COLUMNS
• ROW
• ADDRESS

See Also

This function gives the information about the formatting, location, or contents of the upper-left cell in a reference. Let's see an example if an element is placed in the B4 cell,i.e 4th row

then =CELL(“row”,B2) is 2 =CELL(“row”,B3) is 3

where Infotype is a text value that specifies what type of cell information that want. And 'ref' is the cell that want information about.

	Column1	Column2	Column3	Column4
Row1	12	2
Row2	5	3
Row3
Row4
Row5
Row6

Let's C1R1= PLACE

then =CELL(“contents”,B2) is PLACE