Set Column Values

This dialog is activated by the Set Column Values... command of the Table menu. It allows to fill a column with the result of a function.

The available mathematical functions are listed in the appendix. The special function col(x) can be used to access to the values of the column number x, and the variables i and j can be used to access to the row and column numbers.

Figure 5.48. The Set Column Values... dialog.

The Set Column Values... dialog.

If you make some changes in the table, the values are not computed again. So you have to recall the function in order to update the calculated columns.