Issue in export - exports Key and not the Value

[Haneef Puttur]

Hi,

I have a dropdown column in my grid it works fine for edit.

ViewBag.genderdata = 

(value) B : (text)Boys

(value) G : (text)Girls

(value) A : (text)All

It displays Fine in Grid

When i save it saves the required Key in Database 

When I export to excel , it exports the Key and not the actual Values associated with it.

When I exported the grid , It shows  B in the exported column, actually I want to see : Boys

############# My column data

 col.Field(p => p.EXSCHD_GENDER).HeaderText("Gender").TextAlign(TextAlign.Left).ForeignKeyField("value").ForeignKeyValue("text").EditType(EditingType.Dropdown).DataSource((List<UGApps.Models.list_item>)ViewBag.genderdata).AllowEditing(true).Add();

#########

Thanks in advance for your great help.

Regards

Haneef Puttur

[Jayaprakash Kamaraj]

Hi Haneef, 

 

Thank you for contacting Syncfusion support. 

 

We were unable to reproduce the issue at our end. Please share the following information to find the cause of the issue.    

                                                                                                                

1.     Did you face the issue in initial rendering or any actions performed in Grid?    

2.     Share the video/screenshot to show the issue  

3.     Issue replication procedure.   

4.     Essential studio and browser details.  

5.     If possible, provide an issue reproducing sample or replicate the issue in the following sample.   

 

Sample: http://www.syncfusion.com/downloads/support/forum/127504/ze/SyncfusionMvcApplication24-2014341733 

 

Regards, 

 

Jayaprakash K. 

[Haneef Puttur]

Hi,

I tried the sample you sent with no changes.

When I click the export to excel option the employee Name column is showing the ID in the exported file , however in the grid view it properly displays the Employee name.

I have not made any changes to the sample file you have sent..  I have just referenced the following lines in web config to my version

  <assemblies>

                <!--<add assembly="Syncfusion.EJ, Version=14.4450.0.15, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />-->

                <add assembly="Syncfusion.EJ, Version=14.3450.0.52, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />

                   <!--<add assembly="Syncfusion.EJ.Mvc, Version=14.4500.0.15, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />-->

        <add assembly="Syncfusion.EJ.MVC, Version=14.3500.0.52, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />

      </assemblies>

Please compare the screenshot which shows grid and exported version ... so you will understand the issue better.

Regards

Haneef Puttur

Attachment: issue_e1bfa496.zip

[Jayaprakash Kamaraj]

Hi Haneef, 

 

We were unable to reproduce the issue at our end. Please refer to the below video. 

 

Video: http://www.syncfusion.com/downloads/support/forum/127504/ze/patch-1121426721 

 

Please share the following information to find the cause of the issue.    

                                                                                                              

1.     Did you get any custom patch for any other issue ? If, yes please provide the details. 

2.     browser details.  

 

Regards, 

 

Jayaprakash K. 

[Haneef Puttur]

Dear Sir,

Seems you have attached wrong file. Instead of video you have attached the JS files. Even I tried with replacing the files of those attachement still the same issue persists.

To make it more clear here is my actual problem.

If there is a dropdown listbox in grid , the exported view and grid view looks different.

Grid View : Shows the Values of Listbox and Exported Data shows the key value of the listbox.

I am just using the test solution you have sent and not my codes. I face the same problem in my code as well in the solution you have sent.

If you want to have a look of the issue live i can give a session , you can PM me for access details of my pc.

Thanks for all your time and understanding.

Regards

Haneef Puttur

[Jayaprakash Kamaraj]

Hi Haneef, 

 

A support incident has been created under your account to resolve the issue. Please log on to our support website to check for further updates.  

 

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents 

Regards, 

Jayaprakash K. 

[Haneef Puttur]

Thanks for your support and my issue is resolved.

Regards

Haneef Puttur

[Jayaprakash Kamaraj]

Hi Haneef,  

 

We are happy that the problem has been solved. 

 

Please get back to us if you need any further assistance.   

 

Regards,  

 

Jayaprakash K.