2.54 FAQ-497 How do I use a parameter row or worksheet variable in the Set Column Values dialog?

Last Update: 2/2/2018

You can use the Set Values dialog box to fill one or more worksheet columns with values calculated from a user-defined expression. You can incorporate worksheet header row data in your user-defined expression but you must first declare a variable of type double in the Before Formula Scripts panel of Set Values.

double d1 = %(col(A)[C]$);

Once defined, you can then use the variable directly in the column formula panel, as in this example expression:

A/d1;//or col(A)/d1 in older versions
Scv parameter.gif


For guidance on the syntax used to access worksheet header row data, please see Column Label Row Characters.


See these related topics:


Keywords:set column values, values, formula, column formula, variable, column label row, worksheet header, parameter