Difference between revisions of "Manuals/calci/CELL"

Latest revision as of 16:11, 1 August 2018

CELL (InfoType,Reference)

$InfoType$ 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.

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.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''CELL(type,reference)'''</div><br/>
+<div style="font-size:30px">'''CELL (InfoType,Reference)'''</div><br/>
-*<math>type</math> specifies what type of information we want.
+*<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 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>type</math> specifies what type of information we want.
+*<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 the cell we want to retrieve information.
-*<math>reference</math> is optional.
+*<math>Reference</math> is optional.
-*If <math>reference</math> is omitted, the last cell that was changed will be taken
+*If <math>Reference</math> is omitted, the last cell that was changed will be taken
 {| border="1" cellpadding="1"