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

Use-Variable-in-SetColValue

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

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

See these related topics:

• You can extract metadata from files on import and save this data in the workbook. For information, see: FAQ-423 How do I retrieve and use variables extracted from file name and header?
• To use data contained in Analysis Report Sheets in Set Values calculations, see FAQ-498: How do I use analysis results in the Set Values dialog?
• Beginning with Origin 2016, Project Variables are listed in the Variables menu of Set Values, making it easier to track and use them in your Set Values formulas.

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