This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
set_column_formula [Thu May 20 20:13:19 2010] Alexander |
set_column_formula [Mon Jan 18 17:35:05 2021] (current) Alexander |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Set Column Formula ===== | + | ====== Setting |
- | Use Table -> Set Column Formula menu item to open column | + | === There are two ways to set formula |
- | {{: | + | 1. Select column and write formula in formula string. |
+ | |||
+ | {{: | ||
+ | |||
+ | 2. Use '' | ||
+ | |||
+ | {{: | ||
===== Row Index ===== | ===== Row Index ===== | ||
- | Variable '' | + | Variable '' |
===== Rows Evaluation Order ===== | ===== Rows Evaluation Order ===== | ||
- | Rows are always evaluated one after another from the first to the last in range which was specified in 'Set Column Formula' | + | Rows are always evaluated one after another from the first to the last in the specified |
== Example == | == Example == | ||
- | You can use this behaviour | + | * You can use this behavior |
- | '' | + | |
===== Using Table Data ===== | ===== Using Table Data ===== | ||
- | Only in //Set Column Formula// window. | ||
- | |||
There are two functions to obtain current table cell values in formula: | There are two functions to obtain current table cell values in formula: | ||
- | * '' | + | * '' |
* '' | * '' | ||
Line 27: | Line 30: | ||
* '' | * '' | ||
- | ===== What is " | + | ===== Auto Recalculation on Data Change ===== |
+ | MagicPlot can automatically recalculate formula when data in used columns are changed. Set '' | ||
+ | |||
+ | == Example == | ||
+ | * Set formula '' | ||
+ | |||
+ | ===== Formula Menu in Column Context Menu ===== | ||
+ | You can edit column formula and change auto recalculation mode from column context menu or menu '' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | ===== “Argument is out of range at row #” Warning ===== | ||
Some mathematical functions can be defined only on a certain interval. For example, square root ('' | Some mathematical functions can be defined only on a certain interval. For example, square root ('' | ||
The calculations are not terminated if NaN value occurs in some row(s). | The calculations are not terminated if NaN value occurs in some row(s). | ||
- | In some cases you may want to check if a '' | + | In some cases you may want to check if a '' |
===== See Also ===== | ===== See Also ===== | ||
- | * [[formula|Formula syntax]] | + | * [[expressions]] |