This is an old revision of the document!
To be released in fall 2020.
This is a draft document. The features described are subject to change.
In MagicPlot 2.10 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 /*…*/
notation:
Use Ctrl+/
/ 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 //
or %
) 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
and $A$1
instead of col(A)
and cell(A, 1)
. The old notation also works.
The new notation only works with constant column/cell indexes. Use col
and cell
functions if you need to vary the index, ex. col(i)
and cell(i-1, j+1)
.
The same formula can be set for multiple selected columns. You can use this feature to compute matrices. The i
and j
variables are the current row and column indexes.
You can swap from
and 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 Ctrl+Z
/ Cmd-Z
(Undo) and Ctrl+Shift+Z
/ Cmd-Shift-Z
or Ctrl+Y
/ 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.
Staring MagicPlot 2.10 The 'Data-Baseline' column is no more added to the Table when creating a Fit Plot. The 'Data-Baseline' column contained the Y values with the baseline curve from the Fit Plot subtracted – the Y values that are actually plotted if some Curves are subtracted. 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 2.10 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 simply create a column with Fit Sum and other values in the Table with Fit Plot data using Fit Report tab. The alternatives are: Fit Sum, Baseline, Y with baseline corrected, Residual:
Multiple columns from the selected individual curves (including Fit Sum) can be added to the table using the context menu on the curve itself on the Fit Plot, legend or in the curves list:
The new curves are added to the Table where Y column of the Fit Plot data is located:
The Auto Recalculation is on by default for the created columns and can be switched off.
Ctrl+Shift+H
/ Shift-Cmd-H
.Ctrl+Shift+N
/ Shift-Cmd-N
.The statistics on table rows can now be calculated using Descriptive Statistics dialog. The Columns/Rows switch was added: