Table Of Contents
Tables are used to show and edit numeric data in textual format and often show up in a data-oriented Inspector Editor. Table cells can represent many data types. For example, a table cell can represent a color in RGBA (red, green, blue and alpha) numeric representation, or a pair of scalars representing a 2D point. That representation is called atomic mode. A cell can also represent one component of a composite atomic. For example, a 2D point can be represented as the X Value in column one and the Y Value in column two. The figure below shows the two different modes for a Function graphic.
To alternate between the modes, click-hold or right click on the table and choose the mode or use the table component pop up button (to the right above the table).
The following is an itemization of table features.
The table component is a column, row, a single cell, the column header or the row header. The following lists operations on such components.
- Click on a column header to select a column. Shift-click twice to select an interval of columns. A single click on a column selects only that column for use and hence resulting operations are bounded to that column. A shift-click selects intervals of columns and hence resulting operations span columns.
- Click on a row header to select a row. Shift-click twice to select an interval of rows. A single click on a row selects only that row for use and hence resulting operations are bounded to that row. A shift-click selects intervals of rows and hence resulting operations span rows.
- Click to the left of the column headers, right above the row headers, to make the table respond to user events. Clicking on that area deselects any cells of the table. Then select all cells in the table by typing command-a.
- Click-drag on the cells to select a group of cells and to scroll the table.
- Click-hold to select a single cell and also to bring up a menu of options. Click again to dismiss the options menu while keeping the cell selected.
- Use the table component pop up button (to the right above the table) as another means to select a component.
- Many times, a data graphic can be used to focus on a table component. For example, clicking on a Function graphic on either that graphic's vertex or line segment will select the corresponding row in the table.
Operations On Selection
Once a component is selected then choose one of the following:
- Delete (the delete key or del numeric keypad key) to delete the selected component.
- Copy (command-c, Copy main menu item, or click-hold menu) to copy the selected component.
- Paste (command-v, Paste main menu item, or click-hold menu) to paste the selected component.
- Cut (command-x, Cut main menu item, or click-hold menu) to cut the selected component.
- Click-hold on a selection to bring up the click-hold menu of options.
It should be noted that if you select only one column or row of data (with a click) then that column or row is extended with a subsequent paste. However, if you shift-click an interval of columns or rows then the subsequent paste wraps over the rectangular cell selection.
When you click on a cell and then release, without dragging or holding, then the cell editor is brought forward. Once forward the following applies.
- Edit the cell text using the normal keyboard edit facilities.
- Click Return to enter the data, tab to enter and proceed to the next row in the column or shift-tab to enter and proceed to the previous row in the column.
- Use the arrow keys to enter the text and proceed to an adjacent cell in the direction of the arrow.
- Click the ESC or command-. to cancel cell editing and dismiss the cell editor.
- Use the on-board buttons to enter the data and dismiss, revert or proceed to adjacent cells.
- Move the cursor over a cell to see the information selector. The table information selector shows the cell indices and value. In the case of a blank cell it shows the cell data entry instruction.
The data format for each import operation is define in the respective inspector editor section. Generally:
- For scalar data the column import (paste) format is a list of numbers, for point values it is a list of point components (for example, for 2D points: x1 y1 x2 y2 ... xN yN) where numbers are separated by a blank.
- When importing into numeric columns the format can be much more liberal. Any non-numeric ASCII delimiter can be used such as comma, semicolon, space, tab, Return, etc.
- When importing into a label row the delimiter is a Return character.
- When importing into a 2D point column or cell the format can be a x y numeric pair or a date number pair. The date is formatted as: MM/DD/YY HH:MM:SS.fraction and a numeric number representing the y-value follows.
- If you paste to the entire table then the table import sheet comes forward because pasted data is formatted without explicit delimiters and you need to supply additional information as follows.
- Choosing the double-return delimited format defines column ends as two consecutive return characters in the string serialization of the data.
- Under some circumstances, you can explicitly define the table dimensions and other data attributes.
- If the data dimensions is symmetric then you can transpose the data as needed. Non-symmetrical data can not transpose by inherent limitation.