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

TdxSpreadSheetFormulaBarExecuteInsertFunctionDialogEvent Type

The procedural type of the “Insert Function“ dialog display event.

#Declaration

Delphi
TdxSpreadSheetFormulaBarExecuteInsertFunctionDialogEvent = procedure(Sender: TdxSpreadSheetCustomFormulaBar; var AHandled: Boolean) of object;

#Parameters

Name Type
Sender TdxSpreadSheetCustomFormulaBar
AHandled Boolean

#Remarks

Use the Sender parameter to access the Formula Bar control that raised a TdxSpreadSheetFormulaBarExecuteInsertFunctionDialogEvent event. To access all public members that the control provides, cast Sender to the TdxSpreadSheetFormulaBar class.

Assign True to the AHandled parameter to prevent the built-in “Insert Function” dialog from appearing.

If you need to adjust or customize UI elements of the built-in dialog, derive a custom dialog form from the TdxSpreadSheetInsertFunctionDialogForm class. Then, assign a reference to the custom “Insert Function” dialog form class to the dxSpreadSheetInsertFunctionDialogClass global variable to replace the standard dialog available in spreadsheet controls.

The Formula Bar control’s OnExecuteInsertFunctionDialog event references the TdxSpreadSheetFormulaBarExecuteInsertFunctionDialogEvent type.

See Also