Version

Configuring Cell Editing (XamSpreadsheet)

Purpose

This topic explains how to configure the cell editing feature.

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.

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

Editing Configuration Summary

Editing configuration summary

When the user edits a cell value and confirm the new input the control may navigate to a cell adjacent to the active cell, depending of the configuration.

Note
Note

If there are multiple cells selected in the control may wrap to the adjacent column/cell range.

Editing configuration summary chart

The following table explains briefly the configurable aspects of the XamSpreadsheet and maps them to the properties that configure them. Further details are available after the table.

Configurable aspect Details Properties

Automatically change the active cell after the user confirm edited cell’s new input

Specify the direction in which the active cell should move

Configuring Navigate after Editing

Overview

When the user is editing a cell and confirms the input, the XamSpreadsheet can automatically switch the active cell to another one or preserve the active cell position.

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:

Preserve active cell position after confirming editing

IsEnterKeyNavigationEnabled

false

Move active cell after confirming editing

IsEnterKeyNavigationEnabled

true

Configuring Navigate Direction

Overview

When cell navigation after confirming editing is enabled, you have the ability to configure the direction in which the activation should move to. You can configure the navigation to move in any four directions (up, down, left, right).

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:

Configure the active cell automatic navigation on confirming editing

Related Content

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains how to configure the navigation feature.

This topic explains how to configure the selection feature.

This topic explains how to configure the worksheet’s tabs area.