MagicPlot Manual

Plotting and nonlinear fitting software

User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
table [Wed Dec 23 22:34:43 2009]
table [Mon Jan 18 17:35:24 2021] (current)
Line 1: Line 1:
-===== Table ===== +====== Table Editing ====== 
-In [[MagicPlot]] **Table** is used to store numeric data+In MagicPlot Tables are used to store numeric or text data depending on column type (numeric/text).
-All tables uses floating-point numbers.+
-Empty cells are equal to [[NaN]] values.+==== Data Types ==== 
 +MagicPlot supports these data types in Tables:
-==== Table Context Menu ==== +^ Format  ^ Description  ^ 
-Many table editing functions are available in table context menu.+| Numeric  | 64-bit double precision floating-point numbers ([[wp>IEEE754|IEEE 754]]) 
 +| Text  | Unicode string with unlimited length  |
-==== Moving Columns ==== +  * Data type is set for entire columns. One column may not contain data with different types. 
-Hold ''Ctrl'' key (on Windows and Linux only) or ''Alt'' key (on Windows, Mac OXLinux) and drag column header to rearrange table columns. +  * Empty cells are equivalent to [[NaN|Not-a-Number]] values. 
-If ''Ctrl'' and ''Alt'' keys are not pressed, mouse dragging on header will select the columns.+  * 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 [[expressions]]. 
 +==== 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 ===== 
 +  * [[set_column_formula]] 
 +  * [[expressions]] 
 +  * [[sorting]] 
 +  * [[nan]]
table.1261596883.txt.gz · Last modified: Sun Nov 8 12:20:34 2015 (external edit)