Working with EDE Views - Intergraph Smart Electrical - Help - Hexagon

The software allows you perform various actions in an open EDE view. You can do the following:

Search the EDE View Grid

In the Search field, type 3 or more characters. As you type, the first four suggested items that match the search criteria are displayed under the Search field and also highlighted in yellow in the grid along with the rest of the suggested search results. To clear your search, select the X on the right.

• As you type your search string rows that do not match the string are hidden in the grid. Only items that match the search string are displayed.

• Select on a string displayed under the Search field to locate the string in the grid.

• A search using a wildcard (*) must be used with an alphanumeric character.

• If nothing matches your search criteria the Search field is displayed with a red border.

Group Columns in the Grid

To group your data by a specific attribute, do the following;

1. Select Enable Grouping to open the Group by area.

2. Drag and drop a column header to the Group by area where it says Drag a column header and drop it here to group by that column.

• To remove a column header, drag the column header to anywhere on the grid. To remove all the grouping, select to close the Group by area.

• You can group more than one attribute, by dragging another column header to the Group by area.

• The order in which you apply the groupings changes the filtered results. The filtered results are additive. This means that each additional column header you add will be based on the current filter.

Sorting Items in the Grid

The first time you open an EDE view, the results are displayed in an ascending order based on the Item Name column. To reverse the sorting, select on the column header. A little sort arrow in the column header displays the sort order. Select again to remove the sorting. Press and hold the SHIFT key and select columns to sort by more than one column. Data in columns is sorted alphabetically.

When performing ascending or descending sorts on columns in the EDE View, all cells with NULL values do not participate in the sorting, and always display at the top of the report.

All cells with empty fields do participate in the sorting, and display at the top when sorting a column in ascending order, and at the bottom, when sorting in descending order. The sorting is applied to all pages of the EDE, not just the first page.

Filter Items in the Grid

1. To filter your data, select , in the column header.

2. In the top section - select from the list of values listed in the column. The filtered results will display in the column automatically, as you check the boxes of your preference. Type in the Search field to narrow the available selection if required.
   OR
   In the Show row section, select the required operator. Type a value in the blank field and select And/Or.

3. When you have finished adding criteria to your filter, select Filter to display the filtered results.

• A filtered column displays a blue colored icon .

• If a column includes empty values, a check box with the value [null] appears in the list.

Clear Filters

To clear a filter from a specific column, select on the column you want to remove the filter from.

On the EDE toolbar, select Clear column filters .

Move Columns in the Grid

Select and drag a column header right or left and drop it in the new location.

Edit the Data in the Grid (Edit mode)

Double-click any cell in the grid and type in your new content or change existing content. Select outside the cell to save the contents.

When populating cells with numeric values, enter a number within the minimum and maximum values that an integer data type can handle, between 0 and 2147483647.

Copy/Paste is possible in Edit mode, but only to another cell that is in Edit mode.

Copy and Paste Data

Select the cell (single-select) with the data you want to copy, right-click and from the shortcut menu select Copy. Select the cell (single-select) where you want to paste the data, right-click and from the shortcut menu select Paste.

• A dashed border around the copied cell/s indicate the data has been copied and ready for pasting.

• The standard windows keyboard shortcuts can also be used.

To copy and paste from multiple cells, press and hold the CTRL key, and use the cursor to select (single-select) the cells required. Use the right-click shortcut menu to copy the selected cells. Select (single-select) the cells in the grid where you want to paste the copied information and use the right-click shortcut menu to paste.

The copied information will be cleared (and so will the copy – dash indication) from the clipboard and not pasted, in these cases:

• When the selected cell is in Edit mode (double-clicking on the cell).

• When one or more of these changes are made to the EDE layout:

  • Edit of the EDE definition.

  • Column addition.

  • Column re-order.

  • Splitting screen.

  • Applying a filter.

  • Sorting.

Copy and Paste an Entire Row of Data

1. On the left side of the grid, select in the empty square next to the row you want to copy.

2. On the highlighted row, right-click and from the short cut menu select Copy.

3. Highlight the rows you want to paste the row values to. Use the empty squares next to the rows to highlight them.

4. Select Paste.

Copying a row doesn't copy the Item Tag or read only columns values.

Copy and Paste Data - Troubleshooting

If the copy/paste was not successful, one of the following messages is displayed in the ribbon bar:

• Cannot paste the selected cells:

  • Check you have selected destination cells.

  • Check that the selected cells are not in Edit mode.

  • Make sure that the selected destination layout matches the copied cells layout. The destination area needs to contain the same layout of rows and columns as the source.

  • Check you are not trying to perform multiple pasting with the same content.

• Cannot set lookup value from different source:

You are trying to paste a value from a cell where the values are from a select list to a cell that cannot contain select list values. For example, a value copied from a select list of instrument manufacturers cannot be pasted to a cell with a select list of model numbers. You can only copy select list value to a cell with the same select list type or to a blank cell.

• Cannot set value to read-only cell:

You are trying to paste a value into a cell whose properties have been set to read-only.

• Item cannot be pasted into list:

You are trying to paste a value from a cell whose properties have a dependency on another property. For example, if a panel model in a particular cell is related to manufacturer Honeywell, it can only be pasted into another panel model cell for which the related manufacturer is also Honeywell.

Use the Right-Select Shortcut Menu in the Grid

The shortcut menu provides commands for manipulating items in the grid. These commands are similar to the commands available in the EDE toolbar.

Because the grid does not represent items in a hierarchical layout, make sure when you edit a cell that it doesn't affect other items related to that cell. For example: duplicating a junction box will duplicate all the terminal strips connected to that junction box. The availability of these controls changes from item to item in the grid, and is dependent on one or more of the following conditions:

• If an item is listed in an identifier field column, all the controls are available to it (for example an Instrument Name column, or a Tag Number column).

• If an item is located in an identifier field column, all the controls are available.

• If an item is located at the top of the hierarchy, only the following controls are available: New, Duplicate, and Delete.

• Not all the right-click menu options are available for all the item types.

The Copy and Paste controls are available to all items that are not of item type: Plant, Area, Unit, Project, and Domain.

Freeze Columns in the Grid

To keep information from scrolling off the screen when moving through the grid, you can freeze one or more columns to keep them in place. Hover the mouse cursor over the line dividing between the EDE Explorer and the left side of the grid and drag the separator at the edge of the window to the right. You can drag it either over one column or over a few columns.

Apply text wrapping to a column

By default, wrapping text is not applied to the column data. Wrapping text is applied to individual columns using a shortcut menu. To apply text wrapping to a column, do the following:

• Right-click on the column header and select Wrap Text.

Applying text wrap to a large number of columns can slow the software performance.