xls export shows FALSE on date column

Questionsxls export shows FALSE on date column
c rr asked 1 month 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

4 Answers
Abu Ghufran Staff answered 1 month 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.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
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.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Cedric answered 1 week 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..

Your Answer

19 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?