Columns

RVL script is a spreadsheet containing set of 7 columns in fixed order:

Columns RVL Columns

Default Columns

In addition to these columns there may be any number of other columns used for storing supplementary data, comments, calculations, thoughts etc. Additional columns may be utilized for script itself (i.e. contain expected values or reference data).

Adding Custom Columns

By default RVL always displays column H. It is sometimes useful (to store temp value, add a note etc).

One may show more columns. To do this open the file (i.e. Main.rvl.xlsx) in the spreadsheet editor or Excel and define some values in columns I, J etc respectively:

Excel Columns

Now if you re-open this document in RVL these columns will also be displayed:

Excel Columns

The usage of this columns is up to you. You may use them just for information or make them 'live' by assigning custom actions as will be described in the next section.

Custom Column Actions

RVL is flexible and one may use more columns to implement custom script logic.

The script occupies first 7 columns of the spreadsheet (A, B, C, D, E, F, G).

By default the script also displays the column H. It may also display as many additional columns as needed (see previous section). It may have some value but has no side effects, i.e.:

However the script may see this value and use it for own purpose, i.e.:

You may have one or more custom columns defined in the script to achieve necessary goals. This will require you to override OnRVLScriptStep function as described below.

OnRVLScriptStep

Note: The information below requires some JavaScript knowledge. In most cases all you need is to copy relevant snippet from the documentation or KB to achieve desired behavior

Custom column actions are processed in the OnRVLScriptStep function that should be defined in the User.js file or in the custom library.

function OnRVLScriptStep(item, place, status, ctx, stackItem)

The function is mostly intended for internal use. Here you need information about the following parameters:

See Also