SSReference

A command to help build spreadsheets

Description:

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:

    =SUM(B3:B10)-B2

You could set the following value in the field:

    =SUM(#C##R['Start']#:#C##R[-1]#)

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.