A set cell is one that has a non-empty formula or at least one label defined.

Note that continuous region functions like GoS() look at occupied cells, i.e. cells that have a non-empty formula or are spilled into by the formula in another cell. Here we look at set cells, which exclude cells that are spilled into but are otherwise empty. The reason is that occupied cells will introduce too many dependencies among cells for the functions here, which greatly increases the likelihood of circular dependencies.

GoSmost(a)

Pronounced go south most. This function returns the last set cell in the column containing a.

GoEmost(a)

Pronounced go east most. This function returns the last set cell in the row containing a.

GrowSmost(a)

This function returns a reference to the region bounded by the top left corner at a and the bottom right corner at the cell returned by GoSmost(a). The region reference returned is equivalent to a:GoSmost(a).

GrowEmost(a)

This function returns a reference to the region bounded by the top left corner at a and the bottom right corner at the cell returned by GoEmost(a). The region reference returned is equivalent to a:GoEmost(a).

SEmost(sheet) / SEmost()

Returns a cell reference whose row is the bottom most set cell in sheet, and whose column is the right most set cell in sheet. If sheet is not specified, then the current sheet is used.

Example

$$ \begin{array}{|l|l|l|l|l|} \hline \textrm{name} & & \textrm{tasks} \\ \hline \textrm{Jay} & \textrm{Cruise} & \textrm{World peace} & \textrm{Stop global warning} \\ \hline \textrm{Jane} & \textrm{Yacht} & \textrm{Math} & \textrm{English} & \textrm{Physics} \\ \hline \end{array}

$$

If we wish to highlight the header row, we can extract the region with:

GrowEmost(`name)

The result is equivalent to ``name:tasks (see the Backtick operator) in this example. If we wish to extend to the last column, we can use the RightTill() operator with SEmost() to reference the cell in the top right of the table:

`name >| SEmost()

The above assumes that the example table contains the only cells in the sheet, or that the cell containing Physics is the southeast-most cell in the sheet.