Manuals/calci/CELL

Revision as of 06:16, 20 November 2013 by Abin (talk | contribs) (→‎Description)
CELL(type,reference)


  • specifies what type of information we want.
  • 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.
  •   specifies what type of information we want.
  •   is the cell we want to retrieve information.
  •   is optional.
  • If   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

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