This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
table [Mon Nov 29 23:58:27 2010] Alexander |
table [Tue Nov 8 17:54:39 2016] Alexander |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Table Editing ====== | ====== Table Editing ====== | ||
- | In MagicPlot | + | In MagicPlot |
- | All tables use floating-point numbers in [[wp> | + | |
- | Empty cells are equivalent to [[NaN|Not-a-Number]] values. | + | ==== Data Types ==== |
+ | MagicPlot supports these data types in Tables: | ||
+ | |||
+ | ^ Format | ||
+ | | Numeric | ||
+ | | 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). |
- | {{: | + | {{: |
+ | |||
+ | ==== Changing Column Type ==== | ||
+ | Use '' | ||
==== Columns Numbers ==== | ==== Columns Numbers ==== | ||
Line 17: | Line 30: | ||
==== Moving (Reordering) Columns ==== | ==== Moving (Reordering) Columns ==== | ||
- | Hold '' | + | Hold '' |
If '' | If '' | ||
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. | ||
- | |||
- | {{: | ||
- | |||
- | 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 ===== | ===== Fit Column Widths ===== | ||
- | To fit the width of one column, double click on right separator line in table header. To fit several | + | To fit the width of one column, double click on right separator line in table header. To fit several columns widths, |
===== See Also ===== | ===== See Also ===== | ||
* [[set_column_formula]] | * [[set_column_formula]] | ||
* [[formula]] | * [[formula]] | ||
+ | * [[sorting]] | ||
* [[nan]] | * [[nan]] |