This is an old revision of the document!
To be released in late 2020.
This is a non-complete draft document. The features described are subject to change.
In MagicPlot 3.0 you can set variables in formulas: write an assignment and a semicolon to separate it from the next part of the formula, for example:
a=5; a*a + 2*a + 1. The last expression (after the last semicolon) is the result of the formula and cannot contain an assignment. MagicPlot highlights all usages of the variable at cursor in the edited formula.
The variables can be used in Column Formula, Custom Fit Curve equation and in any other formula fields in MagicPlot.
You can copy the fit equation with variables from the Report tab of a Fit Plot and paste it in any formula field including Column Formula (but it is generally better to use new
Add to Table feature which generates a link instead of copying formula, see below):
You can insert comments in any formula using
Cmd-/ keyboard shortcut to comment selection. Comments can be multi-line. Note that the single line comments using a symbol at the line start (like
%) are not supported because line breaks are not taken into account in MagicPlot formula syntax.
We have simplified Column Formula syntax: column and cell values can be inserted using
$A$1 instead of
cell(A, 1). The old notation also works.
The new notation only works with constant column/cell indexes. Use
cell functions if you need to vary the index, ex.
The same formula can be set for multiple selected columns. You can use this feature to compute matrices. The
j variables are the current row and column indexes.
You can swap
to row indexes to reverse the calculation order. This can be useful if the cell formula contains the value of the previously calculated cell in the same column.
MagicPlot now supports Undo and Redo in formula editor using
Cmd-Z (Undo) and
Cmd-Y (Redo) shortcuts.
We have optimized the program code of the redrawing of the Table to eliminate lags when scrolling and editing a Table with tens or hundreds of thousands of columns.
The special functions listed below are now available in formulas:
MagicPlot uses Colt library for special function implementation. Some boundary and asymptotic values were corrected after the Colt library results.
MagicPlot uses ordinary floating-point numbers to store boolean
true/false values. All boolean operators and functions return
false. However the
if() function can accept any number as a condition, not
0 only. In the old MagicPlot 2.x versions the condition value is interpreted as
false if the value is less or equal to zero. In MagicPlot 3.0 only zero value is interpreted as
false. This change was made to synchronize specification with C-like languages. The change will only be notable if you manually used some calculated numbers as boolean condition in a non-standard way.
We have added negation operator with well-known syntax
! to the expression syntax. Example:
if (!($A > 0), $A, $B).
xor(a, b) returns the boolean exclusive or operation result for operands.
Staring MagicPlot 3.0 The 'Data-Baseline' column is no more added to the Table when creating a Fit Plot. The 'Data-Baseline' column contained the Y values from the Fit Plot with the baseline curves subtracted – the Y values that are actually plotted. This feature was introduced in the early MagicPlot version but it has proved to be mostly annoying.
The 'Data-Baseline' auto-recalculated columns will be preserved when opening old projects in MagicPlot 3.0 for backward compatibility. You can delete these columns manually.
Now you can manually create the 'Data-Baseline' column among with other fit result columns using the Fit Report tab of a Fit Plot, choose
Y with baseline corrected and click on
Add to Table button:
You can now add a column with Fit Sum or other alternatives to the Table which contains Fit Plot data using
Fit Report tab. The alternatives are: Fit Sum, Baseline, Y with baseline corrected, Residual:
Column(s) from the selected curve(s) (including Fit Sum) can be added to the Table using the context menu of the Curve itself in the plot area or in the curves list or from the context menu of the legend symbol:
The new columns are added to the Table where Y column of the Fit Plot data is located:
The created columns have links to the Fit Plot. The Auto Recalculation is on by default for the created columns and can be switched off.
The statistics on table rows can now be calculated using Descriptive Statistics dialog. The Columns/Rows switch was added: