SpreadsheetCellEventArgs.Action Property

Identifies an action which caused a change of the cell value.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

C#

public CellValueChangedAction Action { get; }

VB.NET

Public ReadOnly Property Action As CellValueChangedAction

Property Value

Type	Description
CellValueChangedAction	A CellValueChangedAction enumeration value identifying an action.

Available values:

Name	Description
Edit	End-user has modified the cell value using worksheet editors.
UndoRedo	Cell value has been changed by executing the undo or redo command.
Paste	New value has been pasted into the cell.
API	Cell value has been modified programmatically.

Remarks

Use the Action property to determine whether a change of the cell value is caused by end-user editing, an undo/redo operation or a programmatic cell value modification.

Tip

The WorkbookEventOptions.RaiseOnModificationsViaAPI option should be set to true to raise the SpreadsheetControl.CellValueChanged or SpreadsheetControl.CellValueChanged event when the cell value is modified programmatically.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Action 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