Exporting formatted string to excel not working as intended

[Anonymouse]

Hello, 

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.

Regards,

Martijn D

Attachment: GridExportToExcel_a06ef228.zip

[Piruthiviraj Malaimelraj]

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()); 

Process.Start("Sample1.xlsx"); 

   

 

 

Sample link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/ModifiedSample-1149600385  

Please refer to the below UG for further references, 

https://help.syncfusion.com/windowsforms/gridgrouping/exporting#advanced-excel-exporting  

 

Regards, 

Piruthiviraj