Difference between revisions of "Manuals/calci/CELL"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (21 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''CELL (InfoType,Reference)'''</div><br/> |
| + | *<math>InfoType</math> specifies what type of information we want. | ||
| + | *<math>Reference</math> is the cell we want to retrieve information. | ||
| + | **CELL(), returns information about the formatting, location, or contents of a cell. | ||
| − | + | ==Description== | |
| + | *This function is used to retrieve information about a cell | ||
| + | *The information about the cell can be the contents,size, formatting etc. | ||
| + | *<math>InfoType</math> specifies what type of information we want. | ||
| + | *<math>Reference</math> is the cell we want to retrieve information. | ||
| + | *<math>Reference</math> is optional. | ||
| + | *If <math>Reference</math> is omitted, the last cell that was changed will be taken | ||
| − | + | {| border="1" cellpadding="1" | |
| − | + | |- | |
| − | + | ! width="50"|Type | |
| + | ! width="250"|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== | |
| − | + | {| class="wikitable" | |
| − | = | + | |+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 | ||
| − | + | ==Related Videos== | |
| − | |||
| − | |||
| − | + | {{#ev:youtube|C_XphQ9YBOg|280|center|CELL}} | |
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/COLUMN | COLUMN]] | |
| − | + | *[[Manuals/calci/COLUMNS | COLUMNS]] | |
| − | + | *[[Manuals/calci/ROW | ROW]] | |
| − | + | *[[Manuals/calci/ADDRESS| ADDRESS]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | | | ||
| − | | | ||
| − | | | ||
| − | + | ==References== | |
| − | -- | + | *[http://www.excelfunctions.net/Excel-Cell-Function.html Cell] |
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 17:11, 1 August 2018
CELL (InfoType,Reference)
- specifies what type of information we want.
- is the cell we want to retrieve information.
- CELL(), returns information about the formatting, location, or contents of a cell.
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" |
|
| "width" | Column width of the cell, rounded to the nearest integer. |
Examples
| 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
Related Videos
See Also
References