Spreadsheet References

Spreadsheet references are used in Spreadsheet expressions to refer to cells, ranges, rows, columns, and sheets. They use Excel-style reference notation and are written directly in expressions — without the {} required by standard references.

Cell references are only valid in expressions that appear inside Spreadsheet cells. They cannot be used in general-purpose Iotellect expressions outside of a Spreadsheet context.

A cell reference consists of a column name and a row number, for example B2 or $A$1. The column letter comes first, followed by the row number.

Prefixing the column letter or row number with the ($) character makes that part of the reference absolute. An absolute reference does not adjust when a formula is copied or moved to another cell; a relative reference does.

Single-letter references, such as A, may be recognized lexically, but they are not resolved as valid cell or range references. Use whole-column notation, such as A:A or A:B, to refer to columns.

A range reference consists of two cell references separated by a colon (:).

To refer to all cells in one or more entire columns or rows, omit the row number or the column letter:

To refer to a different sheet within the same Spreadsheet, specify the sheet name before the cell or range reference and separate it with !.

Spreadsheet names that contain spaces are not supported in direct cell reference notation.

In Spreadsheet cell expressions, function names can be written in either lowercase (the standard Iotellect convention) or uppercase (the Excel convention). Both forms are equivalent.

Uppercase function names are accepted only in Spreadsheet cell expressions. In standard Iotellect expressions outside of a Spreadsheet, function names must be written in lowercase.

Was this page helpful?

Tell us more

Send

Thank you!