MagicPlot Manual

Plotting and nonlinear fitting software

User Tools

Site Tools


table

Differences

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
Next revision Both sides next revision
table [Sun Oct 31 18:51:04 2010]
Gray
table [Tue Nov 8 17:54:39 2016]
Alexander
Line 1: Line 1:
 ====== Table Editing ====== ====== 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 use floating-point numbers in [[wp>IEEE754|IEEE 754]] double precision format.+
  
-Empty cells are equivalent to [[NaN|Not-a-Number]] values.+==== Data Types ==== 
 +MagicPlot supports these data types in Tables: 
 + 
 +^ Format  ^ Description 
 +| Numeric  | 64-bit double precision floating-point numbers ([[wp>IEEE754|IEEE 754]]) 
 +| Text  | Unicode string with unlimited length 
 + 
 +Notes: 
 + 
 +  * Data type is set for entire columns. One column may not contain data with different types. 
 +  * Empty cells are equivalent to [[NaN|Not-a-Number]] values
 +  * Values from text columns are treated as empty cells if used as numbers.
  
 ==== Table Context Menu ==== ==== Table Context Menu ====
-Many table editing functions are available in table context menu (right click to open).+Table editing functions are available in table context menu (right click to open).
  
-{{:table_menu.png|Table context menu}}+{{:table_menu.png?nolink|Table context menu}} 
 + 
 +==== Changing Column Type ==== 
 +Use ''Set Column Type'' menu in column context menu to change column type (numeric/text).
  
 ==== Columns Numbers ==== ==== Columns Numbers ====
Line 17: Line 30:
  
 ==== Moving (Reordering) Columns ==== ==== Moving (Reordering) Columns ====
-Hold ''Alt'' key and drag column header to rearrange table 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. If ''Alt'' key is not pressed, mouse dragging on header will select the columns.
  
Line 24: Line 37:
  
 See [[Formula|Formula Syntax]] section for expression syntax. See [[Formula|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-highlighting.png|Table highlighting}} 
- 
-On the screenshot above: 
-  * Column A has no formula 
-  * Column B has formula, auto recalculation is off 
-  * Column C has formula, auto recalculation is on, so this column is not editable 
  
 ===== Fit Column Widths ===== ===== Fit Column Widths =====
-To fit the width of one column, double click on right separator line in table header. To fit selected columns widths, double click on one of column separators in table header. +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 ===== ===== See Also =====
   * [[set_column_formula]]   * [[set_column_formula]]
   * [[formula]]   * [[formula]]
 +  * [[sorting]]
   * [[nan]]   * [[nan]]
table.txt · Last modified: Mon Jan 18 17:35:24 2021 by Alexander