Edit data - Intergraph Smart Materials - 10.4 - Help - Hexagon

Intergraph Smart Materials Help (10.4)

Intergraph Smart Materials
Search by Category
Smart Materials/Smart Reference Data Version

This topic explains concepts like editable and non-editable cells, mandatory and non-mandatory cells, and common cell operations.

Editable and non-editable cells

Cells in the grid can be editable or non-editable. You can enter information only in the cells that are enabled for editing.


1 - Editable cells - data in editable cells which allow you to enter data is shown in black.

2 - Non-editable cells – Data in non-editable cells is shown in grey.

You can enter edit mode by double-clicking a cell or by pressing F2. If you enter edit mode, the entire row enters edit mode, and you can click the adjacent cells to enter data. An edit mode indicator shows that the row is in edit mode.

SHARED Tip You can press the ESC key to exit edit mode.

Mandatory and optional cells

  • Mandatory cells - Mandatory cells are marked with a red asterisk . You must enter data in mandatory cells to proceed to the next step to complete a process.

  • Optional cells - You can choose to leave the optional cells blank to complete a step in the Portal. Optional cells are not marked with an indicator.

Common cell operations

  • Insert a new record - You can insert a new record using Add Com_Add ICON.

  • Update data in a cell - You can update data in a cell by entering edit mode and modifying the existing data. You must click Save to keep the modified information.

  • Undo data modifications - You can undo data modifications by selecting the updated row in the grid and clicking Undo .

  • Delete data in a cell - You can delete the data in a cell by entering edit mode and pressing the DELETE key.

  • Delete a record - You can delete a record using Delete ICON Remove.

  • Save data - You can save inserted, updated or deleted data using Save button. Alternatively, press CTRL + S keys to save.

  • Copy data from a cell - You can copy data from a cell using the shortcut menu options available on a cell. Right-click a cell and click Copy or Copy with header to copy the cell data.


    SHARED Tip Copy with header copies the cell data along with the header name.

    When you copy data from the grid to an Excel sheet, sometimes Excel might not recognize the numbers as numbers because of spacing issues in the cells. For example, this problem happens with French settings. In French settings Char(160) is used as default space. However, Excel recognizes Char(32) as default space. Follow the steps below, if your computer is configured with French settings in Control Panel.

    1. Click Region and Language from Control Panel.

    2. Click Additional Settings...

    3. In the Digit grouping symbol box, backspace to remove the default space (char(160)) and then press space bar to add empty space (char(32)).

  • Paste data into a cell - You can paste data into a cell using the shortcut menu options available on a cell. Right-click a cell and click Paste to paste the copied data.

  • Insert copied rows into a data grid - To insert copied rows into a data grid, select the rows, right-click and click Copy on the context menu, right-click again and click Insert copied rows.

    SHARED Tip You can use Insert copied rows to insert rows copied from an Excel sheet.

  • Save - You can save the data on a page by clicking Save.

Select List

In many places in the application you will see a Select List option. There are three types of select lists.

  • Pre-defined select list Com_LOV_Add ICON - Allows you to pick an option from a pre-defined select list.


    You can search for values from the top and pick a value.

  • Date picker Com_DateAndTime ICON - Allows you to pick a date.


  • Drop-down list: Contains a list of values depending on the data you are entering. This list appears when you click the cell.