End-User Capabilities: Data Editing

• Sep 04, 2018
• 2 minutes to read

Activate Cell Editor

Do one of the following:

• Click a cell.
• Focus a cell (for instance via the keyboard) and press ENTER or F2.
• Focus a cell and press any alpha-numeric key. The editor will be invoked and its contents will be replaced with the pressed character.
• Focus a cell and click the Navigator control’s Edit button.

If a cell editor provides a dropdown, you can activate the editor and open its dropdown by pressing ALT+DOWN ARROW.

Select and Deselect Cell Text

To select text, press F2 or CTRL+A.

To deselect text, press F2.

Close Cell Editor and Accept Changes Made

Do one of the following:

• Press ENTER.

• Click the End Edit button within the Navigator control.

• Click any other grid cell.

• Focus any other control.

Discard Changes

To discard changes made in a cell press ESC.

To discard changes made in all cells in a row/card, do one of the following.

• Press ESC twice.
• Click the Cancel Edit button within the Navigator control.

Open Cell Editor’s Dropdown

Do one of the following:

• Press ALT+DOWN ARROW.
• Click the editor’s dropdown button:

Close Cell Editor’s Dropdown

For all editors providing a dropdown, you can close the dropdown by pressing ALT+DOWN ARROW.

If the calculator is displayed in the dropdown, it can be closed via CTRL+ENTER.

Dropdowns displaying lists of items can be closed by clicking an item with the mouse, or by selecting an item with the keyboard and pressing ENTER.

Change Values

Change Date/Time Values

You can edit these cell values without opening the dropdown calendar. Position the caret at the portion of a date/time value that needs to be changed. To increment the value, press CTRL+UP ARROW. To decrement the value, press CTRL+DOWN ARROW.

Change Numeric Values

To increment the value, press CTRL+UP ARROW. To decrement the value, press CTRL+DOWN ARROW.

Change Values of Cells That Provide Dropdown Items

To select the previous value, press CTRL+UP ARROW. To select the next value, press CTRL+DOWN ARROW.

Note: this feature is not applicable to all editors.

Edit Images

To copy, cut, paste, load and save images in image editors, right click the image and select the required command via the context menu.

See Also

Edit Data. Create Cell Editors. Validate User Input