MagicPlot Manual

Plotting and nonlinear fitting software

User Tools

Site Tools

Trace:
set_column_formula

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
set_column_formula [Sun May 29 13:20:14 2011]
Alexander 		set_column_formula [Thu Jun 7 17:20:45 2012]
Alexander
Line 1: Line 1:
 ====== Setting Column Formula ====== ====== Setting Column Formula ======
-Use Table -> Set Column Formula menu item to open column formula dialog window. See [[formula|formula syntax]] for details.+=== There are two ways to set formula for column evaluation: ===
  
-{{:column_formula.png| Set column formula dialog}}+1. Select column and write formula in formula string. 
 + 
 +{{:column-inspector.png?nolink|}} 
 + 
 +2. Use ''Table -> Set Column Formula'' menu item to open column formula dialog window. See [[formula|formula syntax]] for details. 
 + 
 +{{:column_formula.png?nolink| Set column formula dialog}}
  
 ===== Row Index ===== ===== Row Index =====
Line 35: Line 41:
 {{:formula_submenu.png|Formula Menu}} {{:formula_submenu.png|Formula Menu}}
  
-===== About "Argument is out of range at row #" Warning =====+===== “Argument is out of range at row #” Warning =====
 Some mathematical functions can be defined only on a certain interval. For example, square root (''sqrt(x)'') is not defined for negative numbers (all calculations in MagicPlot are made in real numbers, not complex). Hence if the argument of ''sqrt'' is negative, a [[nan|Not-a-Number (NaN)]] is returned. If a NaN value occurs in some part of formula, the result of calculation will also be a NaN, and corresponding table cells will be empty. Some mathematical functions can be defined only on a certain interval. For example, square root (''sqrt(x)'') is not defined for negative numbers (all calculations in MagicPlot are made in real numbers, not complex). Hence if the argument of ''sqrt'' is negative, a [[nan|Not-a-Number (NaN)]] is returned. If a NaN value occurs in some part of formula, the result of calculation will also be a NaN, and corresponding table cells will be empty.
  
 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 ''NaN'' values occurs in calculations. MagicPlot shows the warning "//NArgument is out of range at row #//". This row number is the **first** row in which ''NaN'' value was returned. MagicPlot also highlights the function or operator which first produces NaN value.+In some cases you may want to check if a ''NaN'' values occurs in calculations. MagicPlot shows the warning "//Argument is out of range at row #//". This row number is the **first** row in which ''NaN'' value was returned. MagicPlot also highlights the function or operator which first produces NaN value.
  
 ===== See Also ===== ===== See Also =====
   * [[formula|Formula syntax]]   * [[formula|Formula syntax]]
set_column_formula.txt · Last modified: Mon Jan 18 17:35:05 2021 by Alexander

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki