Hi. I'm exporting to excel my grid. I have a column with date formatting. In my database i have dates like this: 0000-00-00. in the screen no display in that columns. thats ok.. but if i export to excel, i'm getting this date: "-0001-11-30" in the 0000-00-00 fields.. how can i do to make empty cells when a date 0000-00-00 was found?
3 Answers
I am unable to generate this issue on demos/export/excel.php
Can you recheck with that code.
Screencast: https://streamable.com/kn8yv
Screencast link updated: https://www.dropbox.com/s/ty161a0mxdchcoq/2017-11-07_07-14-16.mp4?dl=1
Your Answer