TableExport icon indicating copy to clipboard operation
TableExport copied to clipboard

xlsx doesn't support dd/mm/yyyy date format as source data

Open wonderiuy opened this issue 6 years ago • 1 comments
trafficstars

Hello, my source table has field with dd/mm/yyyy as date format and when exporting to xlsx the datatype of the filed is "string" and not "date" (this means problem when sorting that column). If I use mm/dd/yyyy in my field the datatype is correctly recognized as "date" but not when the source field has dd/mm/yyyy content. I would expect that the date format dd/mm/yyyy is recognized as a correct date as is. Version 5.2.0

wonderiuy avatar Jul 24 '19 12:07 wonderiuy

As today, the only plugin which support dates in dd/mm/yyyy is the hhurz/tableExport.jquery.plugin

wonderiuy avatar Oct 03 '19 07:10 wonderiuy