Cell values
The value displayed in a cell is the value of the cell.
The value of a cell can be set by user input, by a planned or stored session, or by a template formula.
By default, a value entered in a part number or traceability column is formatted as a text string value, and a value entered in a data column is formatted as a numeric value. For a calculated column, numbers are formatted as numeric values, and any combination of numbers and text is formatted as a string value.
Cell references
There are two types of template commands you can use to access a cell value. You use these commands in the Formula box of step 5 of the Designer:
To access the value of another cell in the template, enter the cell address inside square brackets. For example, the formula [B5] enters the value from cell [B5] into the current cell. You can use this feature to perform mathematical and string functions based on the values displayed in the cells of the data entry template. The cell reference is replaced with the actual cell value before any formula is executed. For example, with a cell value in A1 of "Hello" and a formula "Message [A1]", the [A1] would be changed to "Message 'Hello' " before it is executed.
To access the value of the current cell in the template, use the [current] command. This command is especially useful for restoring the original cell value if the Formula box for this cell contains other commands that produce unexpected results in the cell (such as a 0 value).
SVARs can be used to create a variable cell reference. For example, if you set the value of SVAR 1 = “A2” and then execute a command such as ‘GOTO [SVAR 1]’, the template will go to Cell A2. (MySVars and MySArrs cannot be similarly used for variable cell references.)
Because GainSeeker templates can be used to access data from other applications, such as Microsoft Excel, that use square brackets to reference components, GainSeeker uses a special method to determine whether a bracketed value in a formula is a GainSeeker cell reference. A value between square brackets will be interpreted as a GainSeeker cell reference only if the first character is non-numeric and the last character is numeric.