SpreadsheetCellEventArgs.OldValue Property

Gets the cell’s previous value.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public CellValue OldValue { get; }

VB.NET

Public ReadOnly Property OldValue As CellValue

Property Value

Type	Description
CellValue	A CellValue object.

Remarks

The cell’s new value is returned by the SpreadsheetCellEventArgsBase.Value property.

Related GitHub Examples

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.

C#

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/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")

VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L138

Private Sub spreadsheetControl1_CellValueChanged(ByVal sender As Object, ByVal e As SpreadsheetCellEventArgs) Handles spreadsheetControl1.CellValueChanged
    If e.Action = CellValueChangedAction.UndoRedo OrElse e.OldValue = e.Cell.Value OrElse e.Cell.GetReferenceA1(ReferenceElement.IncludeSheetName) <> "Invoice!B10" Then
        Return