Dropdown List showing the Value rather than the Name Field after selection

Aspose.Cells Product Family
1

Hello,

I have the following issue. I have the following code sample :

cell = cells[“A1”];


cell.CreateValidation(ValidationType.DropDownList,false);
cell.Validation.LoadValueList(_clients.DefaultView, “ID”, “NAME”, false);

What I get is prefectly the dropdown list in the first column. HOwever after I select the value from the list, it shows the ID field rather than the NAME field on the grid.

Please help me !!!

2

Hi,

Yes, by default, when you select an option (textfiled) in the drop down list area and navigate to other cells, the valuefield's value will be shown in the cell. If you still want to display the Name filed in your scenario after the selection / navigation, you may try like:

cell.Validation.LoadValueList(_clients.DefaultView, "NAME", "NAME", false);

Thank you.

3

Hi Amjad,

The problem is I also need the value when I post back to the code for processing. Basically I would need the functionality of a real dropdown that has selected value / name ; but the name is the default display after selection.

Thank you

4 
				Hi Amjad or Henry,<br><br>Possible to let me know if the issue I have is solvable ??<br><br>thank you,<br>
5

Hi,

We will fix this issue within 2 weeks.

Thank you for considering Aspose.

6

Hi Henry,

Has this been implemented ?

Thanks,


7

Hi,

We have not complete this feature yet. And we will finish it ASAP.

Thank you for being patient.

8

Hi Henry,

Any ETA on this??

Thanks,