TTMSFNCDataGridExcelIO.OnCellFormat Event
Occurs during export for each cell, to modify the Excel format (font, fill, alignment, borders, number format) written for it.
API unit family: TMSFNCDataGridExcelIO
Declaring type: TTMSFNCDataGridExcelIO
Syntax
OnCellFormat: TFlxFormatCellGenericEvent;
__property TFlxFormatCellGenericEvent OnCellFormat = {read=FOnCellFormat, write=FOnCellFormat};
Remarks
Raised after OnGetCellFormula and before OnExportColumnFormat. The modified format is only written when Options.ExportCellProperties is True. Not raised during import.
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. |
XlsCol |
One-based worksheet column the cell is written to. |
XlsRow |
One-based worksheet row the cell is written to. |
Value |
Cell text being exported. |
Format |
Format built from the cell's layout; change its fields to alter the output. |