ifference between revisions of "EMO:The Data Grid"
| (6 intermediate revisions by the same user not shown) | |||
| Line 32: | Line 32: | ||
:''<Esc>'' | :''<Esc>'' | ||
| | | | ||
| − | :Discards any changes you have made the field in the current edit | + | :Discards any changes you have made the field in the current edit (only before pressing Enter or Return) |
|- | |- | ||
| | | | ||
| Line 45: | Line 45: | ||
|} | |} | ||
| − | + | == Advanced Data Grid Features == | |
| − | |||
| − | |||
| − | == | + | ===Selecting Cells=== |
| − | + | Select cells in a data grid using the mouse as shown below, or use the arrow keys in conjunction with the SHIFT key (to extend your selection) or SHIFT and CTRL keys (to extend your selection to the end of a row or column). | |
{|class="wikitable" | {|class="wikitable" | ||
| Line 109: | Line 107: | ||
<span style="color:#2E5894"> | <span style="color:#2E5894"> | ||
| − | '''>> To copy all or part of | + | '''>> To copy all or part of an EMO Data Grid to the Windows clip board:''' |
</span> | </span> | ||
| Line 120: | Line 118: | ||
<span style="color:#2E5894"> | <span style="color:#2E5894"> | ||
| − | '''>> Use <CTRL><V> to paste data from the clipboard into a Data Grid.''' | + | '''>> Use <CTRL><V> to paste data from the clipboard into a Data Grid in EMO.''' |
To be noted when pasting: | To be noted when pasting: | ||
| Line 132: | Line 130: | ||
===Creating New Rows in a Table=== | ===Creating New Rows in a Table=== | ||
| + | |||
| + | Some grids allow you to create new rows, for example when adding an entity to a Forecast. You may see an icon for adding an entity (a square with a little sun in the top left hand corner) or you can use the keyboard as follows: | ||
| + | |||
<span style="color:#2E5894"> | <span style="color:#2E5894"> | ||
| − | '''>> To create a new row in a table Data Grid:''' | + | '''>> To create a new row in a table Data Grid using the keyboard:''' |
#Make the Data Grid the current object by clicking in any cell in the Grid (if a Grid contains no rows use one of the Column Headers) | #Make the Data Grid the current object by clicking in any cell in the Grid (if a Grid contains no rows use one of the Column Headers) | ||
#Press <INSERT>: a new blank row of fields will appear | #Press <INSERT>: a new blank row of fields will appear | ||
Latest revision as of 09:38, 11 February 2014
All text-format data appearing in the Presentation Interface appears in a Data Grid. The Data Grid can appear as:
- A single data entry field (a single cell grid)
- A column of data entry fields
- A row of data entry fields
- A table ("grid") of data entry fields
The current row in a data grid (i.e. the row in which the cursor sits) is highlighted with an orange background. The current column in the current row has a white background.
Editing a Data Grid Field
>> To enter text in a field:
1. Make the field current and enter field 'edit mode' by:
- A mouse click inside the field box (a grey border will appear around the cell); or
- Use the Arrow (Up, Down, Left and Right) keys to move to the required field.
You can then either start typing or, in some cells, you must press SPACE before typing.
2. Type the text you want to enter - this will replace all text currently in the field
| Keys | Function |
|---|---|
|
|
|
|
|
|
|
|
Advanced Data Grid Features
Selecting Cells
Select cells in a data grid using the mouse as shown below, or use the arrow keys in conjunction with the SHIFT key (to extend your selection) or SHIFT and CTRL keys (to extend your selection to the end of a row or column).
| Selection | Method | Result |
|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copying to Clipboard
>> To copy all or part of an EMO Data Grid to the Windows clip board:
- Highlighting the fields to be copied with a click and drag operation. Highlighted fields appear light purple except for the first field in the selection which remains uncoloured (but will appear within the grey border around all selected cells)
- Using <CTRL><C> or "<Ctrl><Shift><C>" to copy to the clip board. "<Ctrl><Shift><C>" copies the column headers as well as the data.
Data copied to the clipboard can be copied directly to Excel retaining the columns and rows of the original grid.
Pasting from Clipboard
>> Use <CTRL><V> to paste data from the clipboard into a Data Grid in EMO.
To be noted when pasting:
- Original row and column structure of a cutting from an Excel spreadsheet will be retained
- In cases where the data grid can only accept data for a fixed number of fields, surplus clipboard data will be discarded
- Where an unlimited number of repeating fields can be accepted in the Grid (e.g. Nodes defining a Transmission System) new rows will be created when the number of pasted rows exceeds the number of displayed rows
WARNING! The Data Grid attempts to paste directly in any area you have highlighted within the Grid. If the clipboard holds more fields than the highlighted area, extra clipboard fields are pasted over the top of non-highlighted fields replacing their contents.
Creating New Rows in a Table
Some grids allow you to create new rows, for example when adding an entity to a Forecast. You may see an icon for adding an entity (a square with a little sun in the top left hand corner) or you can use the keyboard as follows:
>> To create a new row in a table Data Grid using the keyboard:
- Make the Data Grid the current object by clicking in any cell in the Grid (if a Grid contains no rows use one of the Column Headers)
- Press <INSERT>: a new blank row of fields will appear
Sorting Fields by Column
Some Data Grid Tables support data sorting.
>> To sort the whole table by the contents of a column alphanumerically:
- Double-click on the Header of the Column you want to sort by (sorts in ascending order)
- Double-clicking again will re-sort the table by column contents in descending order
NOTE: Where a Data Grid supports data sorting, the header for the column currently sorting the table will contain an arrow head facing upwards or downwards depending on whether the data has been sorted in ascending or descending order.