c rr asked 4 weeks ago
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
Abu Ghufran Staff answered 4 weeks ago
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.
Cedric answered 4 weeks ago
Hello,
I tried suggested but still exporting FALSE for the date column..
Abu Ghufran Staff answered 3 weeks ago
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.
