12-09-2015, 08:57 PM (This post was last modified: 12-09-2015 09:03 PM by Tim Wessman.)
Post: #6
 Tim Wessman Senior Member Posts: 2,293 Joined: Dec 2013
(12-09-2015 08:32 PM)jrozsas Wrote:  This information did you get to where?

The built in calculator help for "Cell references and Cell". You have about a page of text describing it there. To find it most easily, type "Cell" and press your calculator HELP key. It will take you right there where you will find this information:

Quote:In most cases, you will be referencing cells directly by their RC names as in A1 or D6 just like in your usual spreadsheet. Only advanced formulas creators or users that need access to spreadsheet data from outside of the spreadsheet numerical view will need to understand the full complexity of cell references.

Examples:
A1:= 100 stores the value 100 in cell A1.
A1:= A2+A3 stores value of A2+A3 in A1 using the current values of A2 and A3.
A1:= 'A2+A3' sets A1 to the formula A2+A3.

Syntax: Cell(RowNumber, ColNumber, [n])

For slightly more complex formulas, Cell(r, c) where r is a row number and c a column number (A=1, B=2 …) is equivalent to ColNameRowNumber. For example, Cell(1,1) is equivalent to A1.

Valid references are:

[$]R[$]C[(n)] or
[$]CellName[(n)] or [$]R1[$]C1:[$]R2[$]C2:[(n)] or [$]CellName1:[$]CellName2[(n)] or a mix of both name and RC syntaxes [$]R:[$]R[(n)] or RowName[(n)] or [$]C:[\$]C[(n)] or
ColName[(n)] or

Where R(1/2) is a Row name and C(1/2) is a Column name or number gives full access to a cell or selection definition or to the cell's attributes.

GETTING THE CONTENT OF CELLS AND SELECTIONS:
If n is not specified and the reference is not used as a Sto destination, the value of the cell/selection is returned.

If the reference is to a single cell, the cell value/content/attributes will be returned.
If the reference is to a single row or column, a list of value/content/attributes will be returned, one for each cell.
If the reference is to a selection, a list of list of value/content/attributes will be retuned, one for each column.
Note: a cell with no associated value is considered as having a value of 0.

If n is specified, the table bellow indicates what attribute of the cell will be returned.

MODIFYING THE CONTENT OF CELLS AND SELECTIONS:
If n is not specified and the reference is used as a Sto destination, the expression associated with the cell/selection is modified.

If a single input is used as the source for more than one destination, the input is duplicated for all destinations. If the input is an expression, relative cell references are updated as needed.
For example: A1:=1; A2:A10:='A1+1';

If n is specified, the table bellow indicates what attribute of the cell will be modified.

CELL ATTRIBUTES (n)
-1: all attributes. If the cell has nothing defined, returns -1, else return a list of 11 objects.
0: value (read only, you can not set the cell value)
1: formula
2: name
3: number format: Standard 0, Fixed 1, Scientific 2, Engineering 3, Floating 4, Rounded 5, unspecified –1
4: number of decimal places: 1 to 11, or unspecified = –1
5: font: -1: 0 to 6, unspecified = –1
6: foreground color: contents color (color, or -1 if unspecified)
7: background color: cell fill color (color, or -1 if unspecified)
8: horizontal alignment: Left = 0, Center = 1, Right = 2 , unspecified = –1
9: vertical alignment: Top = 0, Center = 1, Bottom = 2, unspecified = –1
10: show strings in quotes: Yes = 0, No = 1, unspecified = –1
11: textbook mode (as opposed to algebraic mode): Yes = 0, No = 1, unspecified = –1

Note: As a general rule, -1 means: unspecified or auto.

TW

Although I work for HP, the views and opinions I post here are my own.
 « Next Oldest | Next Newest »