Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetFormulaBar.CancelButtonClick Event

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

#Declaration

public event EventHandler CancelButtonClick

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

SpreadsheetControl_NewFormulaBarElements

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.

See Also