Fields of the spreadsheet can contain expressions, that can be calculated. To calculate these values, the input of the user must be converted to a data structure, which can then be used to calculate the result of that field.
These expressions can contain constants, operations, references to other fields or a parenthesized expression:
expression + expression,
expression / expression
3:1(third column, first row)
We will create these types in
lib/model/expression.ts. First we ...