Calc Tables and Formulas

A Calc Table is a spreadsheet-style block you can drop into a Typealot Document. Insert it from the slash menu (Interactive → Calc Table) or the Insert calc table toolbar button.

Cells and formulas

Cells are addressed A1-style (columns A, B, C… and rows 1, 2, 3…). Click a cell to edit it. To make a cell calculate, start its content with = — for example =A1+B1 or =SUM(A1:A3). Press Enter to commit or Esc to cancel. Cells that hold a formula show a small fx badge.

Picking ranges by clicking

While typing a formula, you can click a cell to insert its reference, or click and drag to insert a range like A1:B3 — just like a spreadsheet.

Resizing the grid

Use the + Row, − Row, + Col, and − Col buttons to add or remove rows and columns. Drag a column border to resize it.

Supported functions

SUM, AVERAGE (also AVG), MIN, MAX, COUNT, COUNTA, ROUND, IF, AND, OR, NOT, ABS, SQRT, POWER, MOD, and PRODUCT. You can also use the operators +, -, *, /, %, and ^, along with comparisons (=, <>, <, >, <=, >=).

Error values

If a formula can't be calculated, the cell shows an error: