This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
table [Fri Feb 25 17:27:50 2011] Alexander |
table [Tue Jan 12 13:38:04 2021] 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: | ||
- | ==== Table Context Menu ==== | + | ^ Format |
- | Many table editing functions are available in table context menu (right click to open). | + | | Numeric |
+ | | 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 [[NaN|Not-a-Number]] values. | ||
+ | * Values from text columns are treated as empty cells if used as numbers. | ||
+ | |||
+ | ==== Changing Column Type ==== | ||
+ | Use '' | ||
==== Columns Numbers ==== | ==== Columns Numbers ==== | ||
Line 21: | Line 27: | ||
==== Editing Table ==== | ==== Editing Table ==== | ||
- | You can edit table cell by double clicking on it. You can enter either a number or an expression | + | You can edit table cell by double clicking on it. You can enter either a number or an expression |
- | + | ||
- | 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. | + | |
- | + | ||
- | The columns which are auto recalculated are not editable and have green background instead of white. | + | |
- | + | ||
- | {{: | + | |
- | + | ||
- | 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. | + | |
+ | ==== 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 ===== | ===== See Also ===== | ||
* [[set_column_formula]] | * [[set_column_formula]] | ||
- | * [[formula]] | + | * [[expressions]] |
+ | * [[sorting]] | ||
* [[nan]] | * [[nan]] |