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 [Mon Dec 28 16:55:49 2009] Alexander |
table [Tue Jan 12 13:38:04 2021] Alexander |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Table ===== | + | ====== Table Editing ====== |
- | In [[MagicPlot]] **Table** is used to store numeric data. | + | In MagicPlot |
- | All tables use floating-point numbers. | + | |
- | Empty cells are equivalent to [[NaN]] values. | + | ==== Data Types ==== |
+ | MagicPlot supports these data types in Tables: | ||
- | ==== Table Context Menu ==== | + | ^ Format |
- | Many table editing functions are available in table context menu. | + | | Numeric |
+ | | 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 '' | + | * Empty cells are equivalent to [[NaN|Not-a-Number]] values. |
- | If '' | + | * Values from text columns are treated as empty cells if used as numbers. |
+ | |||
+ | ==== Changing Column Type ==== | ||
+ | Use '' | ||
+ | |||
+ | ==== Columns Numbers ==== | ||
+ | Columns are enumerated starting with 1. The first 26 columns are additionally denoted with Latin letters: '' | ||
+ | |||
+ | ==== Renaming Columns ==== | ||
+ | Double click on column header to rename table column. You can also use '' | ||
+ | |||
+ | ==== Moving (Reordering) Columns ==== | ||
+ | Hold '' | ||
+ | If '' | ||
+ | |||
+ | ==== Editing Table ==== | ||
+ | You can edit table cell by double clicking on it. You can enter either a number or an expression using [[Formula|formula 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 ===== | ||
+ | * [[set_column_formula]] | ||
+ | * [[expressions]] | ||
+ | * [[sorting]] | ||
+ | * [[nan]] |