Below are the definitions for errors that may occur while writing Planarly formulas.

E1000: Parser error: line X:Y parser message

If there is an error in a formula the Planarly parser will do its best to help you find it. X is going to be 1 in formulas, while Y is the character position in the formula where the error was found. The message will vary depending on the error.

E2001: Eval loop

Planarly always checks that there are no cycles where cells reference cells that immediately or through intermediaries reference them back. E.g. A → B → A, A → B → C→ A. If such a loop is detected, this error occurs.

E2002: Spill conflict

A spill conflict occurs when the results of one or more formulas result in multiple values being attempted to be stored in a cell. You can read more details here.

E3002: Type mismatch

This error occurs when incompatible types are passed as parameters to mathematical operations.

E3007: Unknown identifier: "symbol"

This error occurs when referencing a cell label, a sheet name within a path, or a sheet defined function that has not been defined.

E3012: Division by zero

Self explanatory.

E3019: Expecting num arguments