Version

Cell Editing Interactions (XamSpreadsheet)

Purpose

This topic explains what actions can be performed by the user when editing cells.

Required background

The following table lists the concept and topics required as a prerequisite to understanding this topic.

Type Content

Concept

Infragistics Excel Engine
Topic Purpose

In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine .

This topic explains in details the features of the XamSpreadsheet control from developer perspective.

This topic provides an overview of the visual elements of the XamSpreadsheet control.

In this topic

This topic contains the following sections:

Cell Editing

Cell editing summary

The user has the ability to edit the value of an XamSpreadsheet active cell. The cell value can be edited when the cell is in edit mode. The control supports several ways for entering edit mode depending of the input device which are described further in this topic. After editing a cell value and confirming the new input the control may automatically navigate the active cell to an adjacent cell.

Note
Note

If the user has more than one worksheet selected and edits a cell’s content, all cells with the same address in all other selected worksheets will get the same cell content.

User Interactions and Usability

User interactions summary chart

The following table summarizes the user interaction capabilities of the XamSpreadsheet control.

The user can… Using… Details Configurable?

Enter cell editing mode

  • Double click on the specific cell

  • Press F2 key when the specific cell is active

The specified cell will enter edit mode and the user may change its content
No.png

Enter cell editing mode and replace current value

  • Start typing when the specified cell is active

  • Press Backspace key

The current cell value will be replaced with the value entered by the keyboard. The old value may be restored by pressing Ctrl+Z.
No.png

Exit cell editing and confirm new input

  • Press Enter

  • Press Ctrl+Enter

  • Press Ctrl+Shift+Enter

  • Click on anywhere outside the currently edited cell

The new input will replace old cell value in the underlying worksheet.

The active cell may move to an adjacent cell depending of the control configuration.

The Ctrl+Enter combination will apply the change to all selected cells.

The Ctrl+Shift+Enter combination will apply the change to all selected cells and also will parse any entered formula as an array formula.

Navigate cell value or navigate through cells

The arrow keys

If the user enters edit mode by double clicking on a cell or by start typing, pressing the arrow keys will navigate to an adjacent cell depending of the arrow key pressed.

Note
Note

If you need to have the arrow keys navigating the cell’s value you can rise the ToggleCellEditMode command in code when the cell enters edit mode. For more information on rising commands see the Working with Commands (XamSpreadsheet) topic.

If the user enters edit mode by pressing the F2 key, the left and right arrow keys will navigate through cell value.
No.png

Exit cell editing and discard new input

Press ESC key

The currently edited cell will exit edit mode. The old cell value will be preserved.
No.png
Note
Note

All committed cell editing changes are applying directly on the underlying worksheet data.
Note
Note

For disabling editing of a worksheet refer to the Disabling Editing of a Worksheet (Infragistics Excel Engine) topic.

Related Content

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains the supported user actions when navigating the control’s cells.

This topic explains what operations can be performed by the user with the control’s context menu.

This topic explains the supported user actions when using the Formula Bar.

This topic explains the supported user actions when selecting cells, rows, or columns.

This topic explains what actions can be performed by the user when interacting with the worksheets.