CellReferenceA1Style

[this page | pdf]

Returns text corresponding to a reference to an individual cell, in A1 style.

CellRow and CellCol define the cell itself (e.g. CellRow = 3 and CellCol = 2 corresponds to B3). If FrozenRows is true then the formula created by this function includes absolute row cell references, e.g. B$3, whereas if FrozenRows is false then it creates relative row cell references, e.g. B3. FrozenCols does the same but for column cell references, e.g. $B3 versus B3.

NAVIGATION LINKS
Contents | Prev | Next

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other General functions

-          Computation units used

Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement