Back to Devexpress

SpreadsheetCellCancelEventArgs.Cancel Property

officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetcellcanceleventargs.md

latest3.6 KB
Original Source

SpreadsheetCellCancelEventArgs.Cancel Property

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

Namespace : DevExpress.XtraSpreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public bool Cancel { get; set; }
vb
Public Property Cancel As Boolean

Property Value

TypeDescription
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.

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.

winforms-spreadsheet-how-to-edit-rich-text/CS/SpreadsheetRichText/Form1.cs#L35

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

winforms-spreadsheet-implement-microsoft-excel-format-painter/CS/WindowsFormsApplication1/FormatPainterProvider.cs#L97

csharp
ApplyFormat();
    e.Cancel = true;
}

winforms-spreadsheet-how-to-edit-rich-text/VB/SpreadsheetRichText/Form1.vb#L30

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

winforms-spreadsheet-implement-microsoft-excel-format-painter/VB/WindowsFormsApplication1/FormatPainterProvider.vb#L85

vb
ApplyFormat()
    e.Cancel = True
Else

See Also

SpreadsheetCellCancelEventArgs Class

SpreadsheetCellCancelEventArgs Members

DevExpress.XtraSpreadsheet Namespace