This is an old revision of the document!
In MagicPlot Table is used to store numeric data. All tables use floating-point numbers in IEEE 754 double precision format.
Empty cells are equivalent to Not-a-Number values.
Columns are enumerated starting with 1. The first 26 columns are additionally denoted with Latin letters: A, B, C, … Y, Z, 27, 28, 29, …
. You can use either numbers or letters, addressing cells and columns in formulas.
Double click on column header to rename table column. You can also use Rename Column
context menu item or press F4
.
Hold Alt
key (Option
on Mac, Meta/Win
on Unix-like) and drag column header to rearrange table columns.
If Alt
key is not pressed, mouse dragging on header will select the columns.
You can edit table cell by double clicking on it. You can enter either a number or an expression (e.g. typing pi
in a cell results in 3.1416…
, typing 1+2
results in 3
).
See Formula Syntax section for expression syntax.
MagicPlot marks columns for which formulas or other evaluators (FFT, integral, etc.) are set with blue header color. You can see the formula in column header tool tip.
The columns which are auto recalculated are not editable and have green background instead of white.
On the screenshot above:
To fit the width of one column, double click on right separator line in table header. To fit several selected columns widths, double click on one of column separators in table header.