officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetcelleventargs.md
Gets the cell’s previous value.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public CellValue OldValue { get; }
Public ReadOnly Property OldValue As CellValue
| Type | Description |
|---|---|
| CellValue |
A CellValue object.
|
The cell’s new value is returned by the SpreadsheetCellEventArgsBase.Value property.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the OldValue property.
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.
winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L134
void spreadsheetControl1_CellValueChanged(object sender, SpreadsheetCellEventArgs e) {
if (e.Action == CellValueChangedAction.UndoRedo || e.OldValue == e.Cell.Value ||
e.Cell.GetReferenceA1(ReferenceElement.IncludeSheetName) != "Invoice!B10")
winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L124
Private Sub spreadsheetControl1_CellValueChanged(ByVal sender As Object, ByVal e As SpreadsheetCellEventArgs)
If e.Action = CellValueChangedAction.UndoRedo OrElse e.OldValue Is e.Cell.Value OrElse Not Equals(e.Cell.GetReferenceA1(ReferenceElement.IncludeSheetName), "Invoice!B10") Then Return
Dim invoice As Worksheet = e.Worksheet
See Also
SpreadsheetCellEventArgs Class