SpreadsheetFormulaBar.InsertFunctionButtonClick Event

Occurs when the Insert Function button on the Formula Bar is clicked.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v23.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public event EventHandler InsertFunctionButtonClick

VB.NET

Public Event InsertFunctionButtonClick As EventHandler

Event Data

The InsertFunctionButtonClick 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 InsertFunctionButtonClick event for this purpose. This event fires each time the Insert Function button is clicked.