TTMSFNCDataGridExcelIO.OnDateTimeFormat Event
Occurs during export, for each cell converted to a typed value, to override the date and time formats used to recognise dates and times in its text.
API unit family: TMSFNCDataGridExcelIO
Declaring type: TTMSFNCDataGridExcelIO
Syntax
OnDateTimeFormat: TFlxFormatCellEvent;
__property TFlxFormatCellEvent OnDateTimeFormat = {read=FOnDateTimeFormat, write=FOnDateTimeFormat};
Remarks
Not raised for cells written as text, that is when OnExportColumnFormat leaves ExportCellAsString 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. |
DateFormat |
Initialized with DateFormat; change it for this cell. |
TimeFormat |
Initialized with TimeFormat; change it for this cell. |