VGridControlBase.CellValueChanged Event

Fires immediately after a cell’s value has been changed.

Namespace: DevExpress.XtraVerticalGrid

Assembly: DevExpress.XtraVerticalGrid.v18.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
CellIndex	Gets the processed cell’s index. Inherited from RowCellEventArgs.
RecordIndex	Gets the index of the record containing the processed cell. Inherited from RowCellEventArgs.
Row	Gets the processed row. Inherited from RowEventArgs.
Value	Gets the current cell’s value.

Remarks

The CellValueChanged event fires in response to a cell’s value being changed. The list below points out the possible reasons for this event being raised:

• an end-user has closed an inplace editor after changing the edited cell’s value;
• a cell’s value has been changed using the methods provided by the grid control (for instance, the VGridControlBase.SetCellValue method);

The event doesn’t fire when a cell’s value is changed using the methods provided by the data source.

Example

The following sample code handles the VGridControlBase.CellValueChanged event to change the processed row’s style if its summary data cells value is greater than 100,000. The VGridControlBase.GetCellValue method is used for this purpose.

The image below shows the result.

C#

using DevExpress.Utils;
using DevExpress.XtraVerticalGrid;
using DevExpress.XtraVerticalGrid.Rows;
using DevExpress.XtraVerticalGrid.Events;

private void vGridControl1_CellValueChanged(object sender, CellValueChangedEventArgs e) {
   double sum = 0;
   for (int i = 0; i < vGridControl1.RecordCount; i++)
      sum += Convert.ToDouble(vGridControl1.GetCellValue(e.Row, i));
   if (sum > 100000)
      e.Row.Appearance.BackColor = Color.Red;
   else
      e.Row.Appearance.Options.UseBackColor = false;
}

VB.NET

Imports DevExpress.Utils
Imports DevExpress.XtraVerticalGrid
Imports DevExpress.XtraVerticalGrid.Rows
Imports DevExpress.XtraVerticalGrid.Events

Private Sub VGridControl1_CellValueChanged(ByVal sender As Object, _
ByVal e As CellValueChangedEventArgs) Handles VGridControl1.CellValueChanged
   Dim sum As Double = 0
   Dim i As Integer
   For i = 0 To i < VGridControl1.RecordCount
      sum = sum + Convert.ToDouble(VGridControl1.GetCellValue(e.Row, i))
   Next i
   If sum > 100000 Then
      e.Row.Appearance.BackColor = Color.Red
   Else
      e.Row.Appearance.Options.UseBackColor = False
   End If
End Sub

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference 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-use-the-vertical-grid-for-in-place-editing-and-in-view-mode-e2330/CS/WindowsApplication3/Custom Edit.cs#L86

grid.RecordWidth = RepositoryItemCustomEdit.RecordWidth;
grid.CellValueChanged += OnCellValueChanged;
grid.CellValueChanging += OnCellValueChanging;

VB.NET

how-to-use-the-vertical-grid-for-in-place-editing-and-in-view-mode-e2330/VB/WindowsApplication3/Custom Edit.vb#L88

grid.RecordWidth = RepositoryItemCustomEdit.RecordWidth
AddHandler grid.CellValueChanged, AddressOf OnCellValueChanged
AddHandler grid.CellValueChanging, AddressOf OnCellValueChanging