Set Column Values



This dialog can be opened by double-clicking on a column name. It enables the user to modify the data sets in the spreadsheets.

You can easily navigate through the columns of the active table using the "<<" and ">>" buttons. The "For row (i)" and "to" fields allows you to specify the data range where your formula will be applied. If the value you enter for the "to" field is larger than the number of rows in the table, new rows will be automatically added to it.

When you write a formula in the editor box, the names of the columns must be used under the following form: col(col_name), where "col_name" is any existing column name in the active table. Selecting the column name from the combo box in front of the "Add column" button and then pressing this button makes the editing task easier. You can use the rows index (i) in your formulas, with a synthax like this: col(col_name, f(i)), where f(i) is any valid expression depending on i (it can be a constant as well). You can not use column names in f(i).

You can only use a limited set of parser built-in functions and operators and the "pi" constant under any of the following forms: Pi, PI, pi. Useful information about the buit-in functions is displayed in the left-side grey panel when you select a particular function from the combo box in front of the "Add function" button.