Hello,
When using export button all fields are ok except the date column that shows false at all rows…
this is the column code
$col = array();
$col[“title”] = “Jour”;
$col[“name”] = “date_formation”;
$col[“width”] = “15”;
$col[“sortable”] = true; // false this column is not sortable
$col[“search”] = true; // false this column is not searchable
$col[“editable”] = false;
$col[“edittype”] = “date”;
$col[“formatter”] = “date”;
$col[“formatoptions”] = array(“srcformat”=>’Y-m-d’,”newformat”=>’d/m/Y’);
//$col[“editoptions”][“defaultValue”] = date(“m/d/Y”);
$cols[] = $col;
mysql table field format is date.
This is working in other grid but not there…
Can someone help?
Thanks,
Cedric
Hi,
I am unable to generate this case in latest build.
Try commenting out one of the column options like edittype OR change ddate newformat to m/d/Y and then try export.
Also make sure this column name is not included twice in grid columns. Later column options will always be used.
Hi,
Please try switching excel export library in lib/inc/excel/ by renaming PHPExcel to PHPExcel-2.
It will switch to another alternate excel export method, which may work.