Getting formatted data when exporting from GridGroupingControl to spreadsheet.

Hi Prathima, Sorry for the delayed response and the inconvenience caused. Please refer to the attached sample which allows exporting data from the GridGroupingControl to an Excel spread sheet with the set format in the grid. I have copied the Syncfusion.GroupingGridExcelConverter.cs and made some small changes and it works fine. Let us know if this helps. Regards, Calvin.

42662.zip

Hi Calvin, I tried the property grid[i,j].FormattedText instead of grid[i,j].Text. now its working fine. Thanks, Prathima.

Hi, Calvin: I changed some lines of code in your sample, and detailed the changes and questiones in the Question.doc in the attached zip file. I also going to create a direct-trac for it. Thanks. - Ronnie Lu, 415-378-2949.

Ronnie_Lu_42662.zip

Hi Ronnie, Set the Appearance property of the TableDescriptor instead of Table.Appearance. Below is a code snippet. this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.HorizontalAlignment = GridHorizontalAlignment.Right; this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Format = "#,##0.0000"; Let us know if you need any further assistance. Regards, Calvin.