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.
Unfortunately, activation email could not send to your email. Please try again.

Exporting formatted string to excel not working as intended

Thread ID:





129356 Mar 14,2017 08:27 AM Mar 15,2017 05:25 AM Windows Forms 1
Tags: GridGroupingControl
Asked On March 14, 2017 08:27 AM


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

Piruthiviraj Malaimelraj [Syncfusion]
Replied On March 15, 2017 05:25 AM

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, 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.