A command to help build spreadsheets


This helps build formulas for spreadsheets, including for use with HtmlETable, using position relative flags, or X, Y Lookup values. Only cells that start with an = and contain an even number of # symbols will have this logic applied to them.

For example, when trying to build the following formula:


You could set the following value in the field:


Here are the rules applied. They are loosely based on "R1C1 Reference Style"

The only parameter for this command is a bool value, when set to true (not blank) will return the input for each cell as is when an error is found with a reference or a lookup. When this parameter is not used, these will instead replace those cells with a blank value which keeps the display clean when working near bound edges.