Difference between revisions of "Manuals/calci/CELL"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
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==
 
==Description==
 
*This function is used to retrieve information about a cell
 
*This function is used to retrieve information about a cell
 
*The information about the cell can be the contents,size, formatting etc.
 
*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"
 
{| border="1" cellpadding="1"
Line 97: Line 98:
 
==References==
 
==References==
 
*[http://www.excelfunctions.net/Excel-Cell-Function.html Cell]
 
*[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.

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

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

CELL

See Also

References