Generates a "reference" to a cell, a
, or a region, #a
. If a cell has formula #a
, it would take the value the table of #a
. In contrast, if a cell has formula Ref(#a)
, its value is a single cell that "points" to the region #a
. This value is currently displayed as a string comprised of the UUID for the cell or region and the absolute coordinates of its top left and bottom right corners.
Dereference a reference to a cell or table, i.e. replace each cell that contains a reference with the value of the region it is pointed at. In the example below you can see that DeRef(#c)
results in a region containing the values of a
, #a
and #b
.
Generates a table of the same dimensions as #a
, where each cell is a reference to the corresponding cell in #a
.