MagicPlot Manual

Plotting and nonlinear fitting software

User Tools

Site Tools


Table of Contents

Table Editing

In MagicPlot Tables are used to store numeric or text data depending on column type (numeric/text).

Data Types

MagicPlot supports these data types in Tables:

Format Description
Numeric 64-bit double precision floating-point numbers (IEEE 754)
Text Unicode string with unlimited length
  • Data type is set for entire columns. One column may not contain data with different types.
  • Empty cells are equivalent to Not-a-Number values.
  • Values from text columns are treated as empty cells if used as numbers.

Changing Column Type

Use Set Column Type menu in column context menu to change column type (numeric/text).

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 (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.

Editing Table

You can edit table cell by double clicking on it. You can enter either a number or an expression using Expression Syntax.

Fit Column Widths

To fit the width of one column, double click on right separator line in table header. To fit several columns widths, select multiple columns and 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.txt · Last modified: Mon Jan 18 17:35:24 2021 by Alexander