Hello jsreport team,
I need to prepare an Excel report using the xlsx recipe (NOT html-to-xlsx). There will be a column to show the date. Unfortunately, I failed to set "date" as the cell type.
This link (http://officeopenxml.com/SScontentOverview.php) says that the cell type for the date is "d", that is -
<c t="d"><v>Some Date</v></c>
But this didn't work for me. When I try to preview the report on MS Excel or on Google Sheet, it fails to manage that date type cells.
I also tried to find out the type of a date type cell by unzipping an excel file but found no hints.