Skip to content

cupertino-files / parseFormula

Function: parseFormula()

parseFormula(text): FormulaExpression

Defined in: src/tst/formula-builder.ts:444

Parse infix formula text into a FormulaExpression.

A leading = is optional. The grammar is the practical spreadsheet subset: numbers, quoted strings, TRUE/FALSE, cell references with optional $, ranges, function calls, parentheses, the six comparisons, & + - * / ^, unary + - and postfix %.

Errors name the position, because a formula is user input and "syntax error" is useless when the argument list is forty characters long.

Parameters

text

string

Returns

FormulaExpression

MIT licensed. Independently made — not by Apple in California. Not affiliated with or endorsed by Apple Inc.