cellrange

Returns a vector of all referenced cell values of type scalar. This can be used to draw curves in HyperGraph based on cell values.

Syntax

cellrange("option", cellref1, cellref2...cellrefn)

Argument

"option"
The "option" argument can be one of two types, "range" or "list".
"range"
Each pair of cell references define a cell range.
"range" is inclusive. For example, cellrange("range", b2, b10) returns the range of all cells between the cells b2 and b10.
"range" always has an equal number of arguments: 2, 4, 6, and so on.
"list"
The operation is performed on each cell math reference that follows. Every listed cell will be added.
"list" can have any number of arguments.
cellref1
The cell reference parameters must be legal references to TableView cells. Both relative cell references (b2, c26, e45,...) to cells in the same table and absolute cell references (p1w1_b2, p21w4_c26, ...) to cells in tables in different window and/or pages are supported.

Examples

Get the range vector over the cell ranges B3 - B8 and C12 - D14:
=cellrange("range", B3,B8,C12,D14)
Get the range vector of the cells B3, B8 and C14:
=cellrange("list", B3,B8,C14)

Draw a curve in HyperGraph based on the cell values A10-A13, B10-B13 in the table in window 2:

Figure 1.


Comments

Blank cells and text (string type) cells within the selected range of cells will be ignored when doing the calculations.