TTMSFNCDataGridExcelIO.OnGetCellFormula Event
Occurs during export for each cell, to supply an Excel formula to write instead of the cell value.
API unit family: TMSFNCDataGridExcelIO
Declaring type: TTMSFNCDataGridExcelIO
Syntax
OnGetCellFormula: TFlxGetCellFormulaEvent;
__property TFlxGetCellFormulaEvent OnGetCellFormula = {read=FOnGetCellFormula, write=FOnGetCellFormula};
Remarks
The formula is only written when Options.ExportFormulas is True. Raised first among the per-cell export events.
Parameters
| Name | Description |
|---|---|
Sender |
Grid renderer being exported (not the Excel IO component). |
DataGridCol |
Zero-based grid column of the cell. |
DataGridRow |
Zero-based grid row of the cell. |
Value |
Cell text being exported. |
Formula |
Initialized with the cell text. Set a formula starting with = to write it as a formula; any other value writes the cell normally. |