TdxSpreadSheetFormulaBarExecuteInsertFunctionDialogEvent Type

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

Declaration

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.