We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Exporting formatted string to excel not working as intended


I have a project in which exports a grid grouping control table to excel. 
But when a formatted string is exported. The value is 0 and the type is currency.
My question is how am I able to export a formatted string?

I attached the project to this thread.

Martijn D

Attachment: GridExportToExcel_a06ef228.zip

1 Reply

PM Piruthiviraj Malaimelraj Syncfusion Team March 15, 2017 09:25 AM UTC

Hi Martijn, 
Thanks for your interest in Syncfusion products. 
We have analyzed your sample and we are little bit unclear with your requirement. Here we have modified the sample based on what we had understood from your update (i.e the negative values in decimal will be exported as zero). So in order to resolve this scenario, we suggest you to use the GridGroupingExcelConverterControl instead of GroupingGridExcelConverterControl in your sample. Could you please provide us with the below details, 
·         Provide the simple screenshots of your grid and exported file which shows the reported issue. 
·         Confirm us with whether reported issue is resolved by using GridGroupingExcelConverterControl. 
These would be more useful for us to provide the exact solution at the earliest. 
Code example: 
//To set the currency format. 
this.gridGroupingControl1.TableDescriptor.Columns["ValueDouble"].Appearance.AnyRecordFieldCell.Format = "C"; 
GridGroupingExcelConverterControl converter = new GridGroupingExcelConverterControl(); 
converter.ExportToExcel(this.gridGroupingControl1, "Sample1.xlsx", new ExcelExportingOptions()); 

Sample link: 

Please refer to the below UG for further references, 

Live Chat Icon For mobile
Up arrow icon