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. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exporting formatted string to excel not working as intended

Thread ID:

Created:

Updated:

Platform:

Replies:

129356 Mar 14,2017 12:27 PM UTC Mar 15,2017 09:25 AM UTC WinForms 1
loading
Tags: GridGroupingControl
Anonymouse
Asked On March 14, 2017 12:27 PM UTC

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 [Syncfusion]
Replied On 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()); 
Process.Start("Sample1.xlsx"); 

   
 
 
Sample link: 

Please refer to the below UG for further references, 
 
Regards, 
Piruthiviraj 


CONFIRMATION

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.

Warning Icon 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.Close Icon

;