ExportView issue with null date

[jlarueParticipant]

When using the exportView method to put the grind contents into excel, i am finding that if a date column contains any null values, all values in that column are formatted incorrectly. For example, instead of 2/3/2021, it will be 44230.20833. If there are no nulls in that column, the format will be correct.

i have posted an example at https://jseditor.io/?key=boilerplate . in the javascript, if you remove the record with the null date, the export will work properly.

thanks in advance!

[ivanpeevskiParticipant]

Hi jilarue,

Thank you for reporting the issue!
I have created a work item regarding this and we will work on finding the problem.
Until a fix becomes available, it is possible to manually fix the issue inside the Excel file:
The displayed numbers still represent the actual dates, so by setting the cells format to Date, the values will be formatted correctly

If you face any other problems, please do not hesitate to contact us again.
Best regards,
Ivan Peevski
jQWidgets Team

https://www.jqwidgets.com

[hunmalParticipant]

Hello,

I was wondering what the status on this matter was? I am still seeing this issue, though with the exportdata method.

Best.

[adminKeymaster]

Hi,

As per my knowledge, it is resolved.

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com

[Author]

Posts