Hi Everyone,
if I do not set export format i.e (RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx)
grid will be exported as Excel 97-2003 format and Date cells formatted as they are displayed in the grid.
However once I set it (RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx)
cell containing dates are formatted differently to how they displayed in the Grid.
Is it a bug, how can I get particular cells to preserve their formatting.
Cheers,
Alex