SpreadsheetCellCancelEventArgs.Cancel Property

Gets or sets whether the operation performed on the processed event should be canceled.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

public bool Cancel { get; set; }

VB.NET

Public Property Cancel As Boolean

Property Value

Type	Description
Boolean	true, to cancel the operation; otherwise, false.

Remarks

Set the Cancel property to true to cancel activating the cell editor when handling the SpreadsheetControl.CellBeginEdit event, or to cancel closing the cell editor when handling the SpreadsheetControl.CellEndEdit event.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Cancel 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-display-a-custom-control-over-the-worksheet-cell-t208764/CS/SpreadsheetCustomization/Form1.cs#L106

{
    e.Cancel = true;
}

how-to-implement-the-basic-idea-of-the-microsoft-excel-format-painter-feature-for-spreadsh-t590741/CS/WindowsFormsApplication1/FormatPainterProvider.cs#L97

    ApplyFormat();
    e.Cancel = true;
}

how-to-edit-rich-text-in-spreadsheetcontrol/CS/SpreadsheetRichText/Form1.cs#L35

{
    e.Cancel = true;
    using (RichTextEditForm richEditForm = new RichTextEditForm(e.Cell))

VB.NET

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/VB/SpreadsheetCustomization/Form1.vb#L97

If CheckCondition() Then
    e.Cancel = True
End If

how-to-implement-the-basic-idea-of-the-microsoft-excel-format-painter-feature-for-spreadsh-t590741/VB/WindowsFormsApplication1/FormatPainterProvider.vb#L93

    ApplyFormat()
    e.Cancel = True
Else

how-to-edit-rich-text-in-spreadsheetcontrol/VB/SpreadsheetRichText/Form1.vb#L30

If e.Cell.HasRichText Then
    e.Cancel = True
    Using richEditForm As New RichTextEditForm(e.Cell)