https://drive.google.com/file/d/1SKJ_ZKnhVPnyV7sKgDPqLGAfmTGLOyzh/view?usp=sharing
 
issue image
 

Please check this answer:

Exporting Grid with Dropdowns only displays values

I think I am having the same problem.  That link is no longer valid, Abu.  Can you reproduce the information here?

I have a table which has the column name ‘class’ which can contain one of two values ‘user’ or ‘admin’.

All my users but one are a ‘user’, but when I export, they all have class ‘admin’.  The admin has a blank class.

My column is defined like this:

$class_vals = ‘user:user;admin:admin’;

$col = array();
$col[“title”] = “Class”; // caption of column, can use HTML tags too
$col[“name”] = “class”; // grid column name, same as db field or alias from sql
$col[“width”] = “50”; // width on grid
$col[“hidden”] = false;
$col[“editable”] = true;
$col[“edittype”] = “select”;
$col[“formatter”] = “select”;
//$col[“formoptions”] = array(“elmsuffix”=>'<font color=red> *</font>’);
$col[“editoptions”] = array(“value” => $class_vals, “separator” => “:”, “delimiter” => “;”);

Check-out the Demos Section \demos\appearance\dropdown.php

I think the broken link is to the old support site. If you use the search you should be able to find the referenced information – but it’s quite old, a lot of updates have happened and I think this issue was fixed, depending how old your version is.

This is the current link for that old support article I found by searching:

Exporting Grid with Dropdowns only displays values

Thanks

Mike

Strange… I have a very new version (this year!).