Planarly tables are composed of cells that can contain a handful of primitive types. These primitive types are:

Boolean

Boolean values can only take the values of True or False. They are both constants and reserved words.

Blank

This is a special value that denotes that a cell is empty. As shown below, it can be used explicitly to create empty cells.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/493e735e-366b-40ec-9582-44425aa8692c/Screenshot_2021-05-27_at_16.45.55.png

The value Blank can also be used to filter cells before further operations.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a9890b7b-12fd-4d20-b5d5-a973de4d9da6/Screenshot_2021-05-27_at_16.48.15.png

In the first image above, you can see that Blank can be used in basic numerical and string operations. For numerical operations, Blank acts similar to 0, but not exactly:

X + Blank = X (similar to X + 0)

X - Blank = X

Blank - X = -X

X * Blank = Blank

X / Blank results in an error.

In string concatenation, Blank is treated as an empty string. In the first image you can see a portion of the formula "A" + Blank + "B" evaluates to AB in the first cell of row 2.

Integers

Planarly supports integers in the approximate range of ±10^18.

Floating point numbers