GridViewBase.CellValueChanged Event

Occurs after a cell’s value has been changed.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v19.2.dll

Declaration

C#

public event CellValueChangedEventHandler CellValueChanged

VB.NET

Public Event CellValueChanged As CellValueChangedEventHandler

Event Data

The CellValueChanged event's data class is CellValueChangedEventArgs. The following properties provide information specific to this event:

Property	Description
Cell	Gets or sets the CellValue object consisting of information about the cell being processed. Inherited from CellValueEventArgs.
Column	Gets a column that contains the edited cell. Inherited from CellValueEventArgs.
Handled	Gets or sets a value that indicates the present state of the event handling for a routed event as it travels the route. Inherited from RoutedEventArgs.
OldValue	Gets the cell’s previous value.
OriginalSource	Gets the original reporting source as determined by pure hit testing, before any possible Source adjustment by a parent class. Inherited from RoutedEventArgs.
RoutedEvent	Gets or sets the RoutedEvent associated with this RoutedEventArgs instance. Inherited from RoutedEventArgs.
Row	Gets the processed row. Inherited from RowEventArgs.
RowHandle	Gets the processed row’s handle. Inherited from RowEventArgs.
Source	Gets or sets a reference to the object that raised the event. Inherited from RoutedEventArgs.
Value	Gets or sets the processed cell’s value. Inherited from CellValueEventArgs.

The event data class exposes the following methods:

Method	Description
InvokeEventHandler(Delegate, Object)	When overridden in a derived class, provides a way to invoke event handlers in a type-specific way, which can increase efficiency over the base implementation. Inherited from RoutedEventArgs.
OnSetSource(Object)	When overridden in a derived class, provides a notification callback entry point whenever the value of the Source property of an instance changes. Inherited from RoutedEventArgs.

Remarks

A View raises the CellValueChanged event after a cell’s value has been changed:

• An end user has changed a cell’s value and closed its in-place editor.
• A cell’s value has been changed in code using the GridControl.SetCellValue method.

The code sample below shows how to update summary values each time a cell value is edited:

Xaml

<dxg:GridControl AutoGenerateColumns="AddNew" 
                 EnableSmartColumnsGeneration="True" 
                 ItemsSource="{Binding Sales}">
    <dxg:GridControl.TotalSummary>
        <dxg:GridSummaryItem FieldName="UnitPrice" SummaryType="Sum"/>
    </dxg:GridControl.TotalSummary>
    <dxg:GridControl.View>
        <dxg:TableView CellValueChanged="view_CellValueChanged" />
    </dxg:GridControl.View>
</dxg:GridControl>  

C#

private void view_CellValueChanged(object sender, DevExpress.Xpf.Grid.CellValueChangedEventArgs e) {
    view.CommitEditing();
}

VB.NET

Private Sub view_CellValueChanged(ByVal sender As Object, ByVal e As DevExpress.Xpf.Grid.CellValueChangedEventArgs)
    view.CommitEditing()
End Sub 

The CellValueChanged event is not fired when a cell’s value is changed using the methods provided by a data source.

The event parameter’s RowEventArgs.RowHandle and CellValueEventArgs.Column properties identify the cell whose value has been changed. The CellValueEventArgs.Value property returns the cell’s new value.

Tip

Topic: Obtain and Set Cell Values in Code

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CellValueChanged event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-filter-a-lookupedit-in-one-column-based-on-the-value-of-another-column-e3826/VB/MainWindow.xaml#L29

<dxg:GridControl.View>
    <dxg:TableView AutoWidth="True" CellValueChanged="TableViewCellValueChanged" ShownEditor="OnTableViewShownEditor" HiddenEditor="TableVieHiddenEditor"/>
</dxg:GridControl.View>

how-to-change-background-color-for-modified-cells-e1297/CS/HighlightChangedCellBehavior.cs#L32

AssociatedObject.CustomUnboundColumnData -= OnGridCustomUnboundColumnData;
View.CellValueChanged -= OnViewCellValueChanged;
base.OnDetaching();

how-to-create-checkable-grouping-in-gridcontrol-t127563/CS/DevExpress.Example03/CheckableGroupBehavior.cs#L113

this.AssociatedObject.EndGrouping += AssociatedObject_EndGrouping;
(this.AssociatedObject.View as TableView).CellValueChanged += GridCellValueChanged;
(this.AssociatedObject.View as TableView).CellValueChanging += CellValueChanging;

VB.NET

how-to-change-background-color-for-modified-cells-e1297/VB/HighlightChangedCellBehavior.vb#L38

RemoveHandler AssociatedObject.CustomUnboundColumnData, AddressOf OnGridCustomUnboundColumnData
RemoveHandler View.CellValueChanged, AddressOf OnViewCellValueChanged
MyBase.OnDetaching()

how-to-create-checkable-grouping-in-gridcontrol-t127563/VB/DevExpress.Example03/CheckableGroupBehavior.vb#L121

AddHandler Me.AssociatedObject.EndGrouping, AddressOf AssociatedObject_EndGrouping
AddHandler TryCast(Me.AssociatedObject.View, TableView).CellValueChanged, AddressOf GridCellValueChanged
AddHandler TryCast(Me.AssociatedObject.View, TableView).CellValueChanging, AddressOf CellValueChanging