SpreadsheetFormulaBar.CancelButtonClick Event

Occurs when the Cancel button on the Formula Bar is clicked.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public event EventHandler CancelButtonClick

VB.NET

Public Event CancelButtonClick As EventHandler

Event Data

The CancelButtonClick event's data class is EventArgs.

Remarks

The Formula Bar contains three buttons, each of which has a default action:

• Cancel button cancels the user input;
• Enter button completes the user edit and evaluates the entered formula;
• Insert Function button inserts a function from the Function Library.

This default action is performed each time a user clicks the button. You can however, override the default behavior or perform additional actions when the button is clicked. Handle the CancelButtonClick event for this purpose. This event fires each time the Cancel button is clicked.