wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-f645d501.md
Occurs after a cell value has been changed.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public event CellValueChangedEventHandler CellValueChanged
Public Event CellValueChanged As CellValueChangedEventHandler
The CellValueChanged event's data class is SpreadsheetCellEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| Action | Identifies an action which caused a change of the cell value. |
| Cell | Gets the cell for which the event is fired. Inherited from SpreadsheetCellEventArgsBase. |
| ColumnIndex | Gets the index of the column that contains the cell. Inherited from SpreadsheetCellEventArgsBase. |
| Formula | Gets the formula that is currently contained in the cell. Inherited from SpreadsheetCellEventArgsBase. |
| FormulaInvariant | Gets the formula in the invariant culture that is currently contained in the cell. Inherited from SpreadsheetCellEventArgsBase. |
| OldFormula | Gets the cell’s previous formula. |
| OldFormulaInvariant | Gets the cell’s previous formula in the invariant culture. |
| OldValue | Gets the cell’s previous value. |
| RowIndex | Gets the index of the row that contains the cell. Inherited from SpreadsheetCellEventArgsBase. |
| SheetName | Gets the name of the worksheet that contains the cell. Inherited from SpreadsheetCellEventArgsBase. |
| Value | Gets the value currently contained in the cell. Inherited from SpreadsheetCellEventArgsBase. |
| Worksheet | Gets the worksheet that contains the cell. Inherited from SpreadsheetCellEventArgsBase. |
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.
if (control != null)
control.CellValueChanged -= SpreadsheetControl_CellValueChanged;
control = value;
If _control IsNot Nothing Then
RemoveHandler _control.CellValueChanged, AddressOf SpreadsheetControl_CellValueChanged
End If
See Also