TTMSFNCDataGrid + TTMSFNCDataGridExcelIO - how to import numbers formats from Excel to DataGrid ?

FNC TMS FNC UI Pack
1

Hi!

Is there a way to import a XLS and see the number formats as in the original XLS file ?

I’ve checked Option.ImportCellFormats, but it appears to import every other cell formatting options than the number format.

Cell data custom formatting/displaying must be all event driven ?

I must let the user open some XLSs I don’t have control over them, and they have percentage cells (89,44%), cells with thousand separators (1.530) and cells with thousand separators + decimal digits (1.530,47). He should be able to edit those values in datagrid and view them as originally formatted in XLS.

Is there a way to automatically apply this when importing from XLS?

How could I apply those 3 formats from XLS without using OnGetCellDisplayValue , once the user could open any of his XLSs ?

5

Hi, right now there is no option to import number formatting, it’s done via events. We’ll add this on our feature request list.