IWAdvWebGridExcelIO problems with formatting float values

IW TMS IntraWeb Component Pack
1

I am using the IWAdvWebGridExcelIO to export data from a IWAdvWebGrid.

When I export float values with eg 1 or 2 decimals does it ignore my settings but they are presented ok in the grid using CellFormat to "%.1f" or "%.2f"

I have set the ExportCellAsString to false in the OnExportColumnFormat
I have set the Format.Format to "#.#" or "#.##" (One or two decimals) but it seems to ignore this setting completely.

Can you guide me in the right direction to get it to work.

I am using the latest version og the Intraweb packages.

Regards Peter

2

Hi,

Can you please try using the excel format?

Format.Format := '0.00';