MTM_QueryExcelNumberFormat

This message is sent once for every exported column and cell while exporting to Excel.
If a format is returned, M!Table sets the appropriate cell(s) in Excel to the specified number format before pasting the cell data.

Parameters
wParam
Handle of the column
lParam
Number of the row if the number format of a cell is queried, TBL_Error if the number format of a column is queried

Return
Must be the result of SalHStringToNumber or 0.
M!Table uses the string passed to SalHStringToNumber as number format in Excel.

Example
In this example the number format in Excel is set to the (german) number format "TT.MM.JJJJ hh:mm:ss":
On MTM_QueryExcelNumberFormat
Return SalHStringToNumber( "TT.MM.JJJJ hh:mm:ss" )

Remarks
If a number format for a numeric column is returned, M!Table exports all cells of the column unformatted.

Created with the Personal Edition of HelpNDoc: Single source CHM, PDF, DOC and HTML Help creation