Difference between revisions of "Manuals/calci/CELL"
Jump to navigation
Jump to search
Line 49: | Line 49: | ||
|- | |- | ||
| "protect" | | "protect" | ||
− | | | + | | Returns 1 if the cell is locked. Returns 0 if the cell is not locked. |
|- | |- | ||
| "row" | | "row" | ||
− | | | + | | Row number of the cell. |
|- | |- | ||
| "type" | | "type" | ||
− | | | + | | *Returns "b" if the cell is empty. |
+ | *Returns "l" if the cell contains a text constant. | ||
+ | *Returns "v" for all others | ||
|- | |- | ||
| "width" | | "width" | ||
− | | | + | | Column width of the cell, rounded to the nearest integer. |
|} | |} | ||
Revision as of 06:10, 20 November 2013
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.
|
"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.
|
"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