Released January 18, 2021.
MagicPlot Full Release History
MagicPlot 3.0 provides the full-functional 30-days trial period without entering a license key. Some features will be disabled at the end of the trial period if the license key is not entered. This limited-features application may be used for non-commercial purposes as the 'Student' edition of the previous versions.
MagicPlot 3.0 utilizes the new unified interface style FlatLaf on all supported operating systems. It is fully HiDPI/Retina display compatible.
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 /*…*/
notation:
Press Ctrl+/
on Windows/Linux or Cmd-/
on Mac OS to comment selection. Comments can be multi-line. Note that the single line comments using a symbol at the line start are not supported because line breaks are not taken into account in MagicPlot formula syntax.
The special functions listed below are now available in formulas. MagicPlot special function implementation is based on the well-known Colt 1.2 scientific open-source library.
Bessel functions | |
---|---|
besselj(n, x) | Bessel function of the first kind of integer order n |
bessely(n, x) | Bessel function of the second kind of integer order n |
besseli(n, x) | Modified Bessel function of the first kind of order n = 0, 1 |
besselie(n, x) | Exponentially scaled modified Bessel function of the first kind of order n = 0, 1 |
besselk(n, x) | Modified Bessel function of the second kind of integer order n |
besselke(n, x) | Exponentially scaled modified Bessel function of the second kind of order n = 0, 1 |
Error function | |
erf(x) | Error function |
erfc(x) | Complementary error function, 1 - erf(x) |
Gamma function | |
gamma(x) | Gamma function |
gammainc(a, x) | Regularized lower incomplete gamma function. x — the integration end point, a — the parameter of the gamma distribution |
gammaincc(a, x) | Regularized upper incomplete gamma function. x — the integration start point, a — the parameter of the gamma distribution |
gammaln(x) | Logarithm of the absolute value of the gamma function |
Beta function | |
beta(a, b) | Beta function. The values of a and b must be nonnegative |
betainc(x, a, b) | Incomplete beta function. a, b — parameters of the beta function, must be nonnegative, x — the integration end point, must be in the closed interval [0, 1] |
Reciprocal trigonometric functions | |
---|---|
csc(x) | Cosecant of an angle measured in radians, csc(x) = 1/sin(x) |
sec(x) | Secant of an angle measured in radians, sec(x) = 1/cos(x) |
ctg(x) | Cotangent of an angle measured in radians, ctg(x) = 1/tan(x) |
Other | |
xor(a, b) | Logical exclusive-OR operation |
rem(x, y) | Computes the remainder of the division operation x/y, same as x % y . Added for compatibility |
isNaN(x) | Checks if x is NaN (Not a Number) or empty cell (see manual topic) |
MagicPlot uses ordinary floating-point numbers to store Boolean true/false
values. All Boolean operators and functions return 1
for true
and 0
for false
. However the if()
function can accept any number as a condition, not 1
and 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.
App version | The result of if(condition, if_true, if_false) |
---|---|
MagicPlot 3.0 and later | If condition != 0 returns if_true value. Returns if_false value otherwize. |
MagicPlot 2.9.3 and earlier | If condition > 0 returns if_true value. Returns if_false value otherwize. |
f = $A > 0; if (!f, $A, $B)
. xor(a, b)
returns the Boolean exclusive or operation result for operands.
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 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.
We have optimized the program code of the redrawing of the Table to eliminate lags when scrolling and editing a Table with hundreds of thousands of columns.
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.
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 and it has proved to be rarely used.
The 'Data-Baseline' auto-recalculated columns in old projects will be preserved when opening in MagicPlot 3.0 for backward compatibility. In MagicPlot 3.0 you can delete these columns manually.
The analog of the 'Data-Baseline' column can be created in MagicPlot 3.0 using the 'Fit Report' tab of a Fit Plot. Choose Y with baseline corrected
in the drop-down list and click Add to Table
button:
The statistics on table rows can now be calculated using Descriptive Statistics dialog. The Columns/Rows switch was added:
New marker types were added: vertical and horizontal dash.
Ctrl+Shift+H
/ Shift-Cmd-H
.Ctrl+Shift+N
/ Shift-Cmd-N
.See also: MagicPlot Full Release History
The features listed below are available in MagicPlot after entering the license key only and will be disabled after the 30-days trial period.