The canonical text of a formula AST (without =): functions and references in capitals, , between arguments, texts with "" for a quotation mark, parentheses only where needed. Used for moving formulas and the Excel export.
=
,
""
the syntax tree
the formula text
formatFormula({ kind: "binary", op: "*", left: { kind: "ref", row: 1, col: 1, absRow: false, absCol: false }, right: { kind: "literal", value: 2 } }); // "B2*2" Copy
formatFormula({ kind: "binary", op: "*", left: { kind: "ref", row: 1, col: 1, absRow: false, absCol: false }, right: { kind: "literal", value: 2 } }); // "B2*2"
1.1.99
The canonical text of a formula AST (without
=): functions and references in capitals,,between arguments, texts with""for a quotation mark, parentheses only where needed. Used for moving formulas and the Excel export.