MagicPlot Manual

Plotting and nonlinear fitting software

User Tools

Site Tools


This is an old revision of the document!

Table Editing

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.

Table Context Menu

Many table editing functions are available in table context menu (right click to open).

Table context menu

Columns Numbers

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.

Renaming Columns

Double click on column header to rename table column. You can also use Rename Column context menu item or press F4.

Moving (Reordering) Columns

Hold Alt key and drag column header to rearrange table columns. If Alt key is not pressed, mouse dragging on header will select the columns.

Editing Table

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.

Displaying Column Formulas in Table

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.

Table header highlighting

On the screenshot above:

  • Column A has no formula
  • Column B has a formula, auto recalculation is off
  • Column C has a formula, auto recalculation is on, so this column is not editable

Fit Column Widths

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.

See Also

This website uses cookies. By using the website, you agree with storing cookies on your computer. Also you acknowledge that you have read and understand our Privacy Policy. If you do not agree leave the website.More information about cookies
table.1291064307.txt.gz · Last modified: Sun Nov 8 12:20:34 2015 (external edit)