A table in a spreadsheet is normally thought of as any rectangular grid of data. Data might be missing from columns or rows so not all columns and rows are the same length, but overall the shape is still rectangular.
In Planarly, everything is a table. A single column is a table. A row is a table. A single cell is a table.
A table can be static data entered into a sheet or it can be an in-memory data structure created by a formula.
Setting a cell label in the top left and bottom right corners allows you to use the table in a formula. As can be seen in the example below, using the *label* and *Zlabel* format for those cell labels, allows the use of the # operator to reference the table in a formula. You can read more about # and the Z prefix here.
Alongside tables Planarly has regions. A region is a reference to a table, either static or in-memory. Regions are marked by heavy grey corners within a sheet. These delineate the spill area of a cell.
In the example above, the table created by the formula #a * 2 is a region.
Since the formula in a single cell can create a region of any size, these corner markers signal which cell created the region and the region boundaries.
Below, a large region is created with a formula using the Ones() function.
Transforming data in a spreadsheet can take several steps. In Planarly, these steps will create regions. You may not want to reference an entire region. In this case, you can use labels to define a table within a region.
With a single label you can reference a region. Below, the label b is added to the top left cell of the calculated region from the previous example. The entire region is then referenced in a lower table using #b.