This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
table [Mon Jun 3 16:40:57 2013] Alexander |
table [Mon Jan 18 17:35:24 2021] Alexander |
||
---|---|---|---|
Line 8: | Line 8: | ||
| Numeric | | Numeric | ||
| Text | Unicode string with unlimited length | | Text | Unicode string with unlimited length | ||
- | |||
- | Notes: | ||
* Data type is set for entire columns. One column may not contain data with different types. | * 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. | * Empty cells are equivalent to [[NaN|Not-a-Number]] values. | ||
* Values from text columns are treated as empty cells if used as numbers. | * Values from text columns are treated as empty cells if used as numbers. | ||
- | |||
- | ==== Table Context Menu ==== | ||
- | Table editing functions are available in table context menu (right click to open). | ||
- | |||
- | {{: | ||
==== Changing Column Type ==== | ==== Changing Column Type ==== | ||
Line 34: | 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. | + | |
- | ===== 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]] | + | * [[expressions]] |
* [[sorting]] | * [[sorting]] | ||
* [[nan]] | * [[nan]] |