c rr asked 2 months 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 2 months 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 2 months ago
Hello,
I tried suggested but still exporting FALSE for the date column..
Abu Ghufran Staff answered 1 month 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.
Cedric answered 4 weeks ago
It fails if I rename the lib. And all my other grids are working fine with the current lib.
It’s only this new grid… I don’t know where the false is coming..
