Is there a way to export dates as dates to Excel? I am not talking about the format of the date, as MM/DD/YYYY, which the API already handles. I am talking about the resulting Excel. Right now, the data type is "General" when you right click the cell in Excel, unless you actually edit the date column. Once you edit it, it is in the proper Excel "Date" type, and is right justified in the Excel Cell.
In the code, we have setDateFormat("MM/dd/yyyy");, so the Excel looks correct. It is purely the Excel column type that is the problem.
BTW, using version 1.0.1 for a Vaadin 7 application.
I attached the screen I am exporting, with a date column, and the corresponding excel export, to explain what I mean.
Is there a way to export dates as dates to Excel? I am not talking about the format of the date, as MM/DD/YYYY, which the API already handles. I am talking about the resulting Excel. Right now, the data type is "General" when you right click the cell in Excel, unless you actually edit the date column. Once you edit it, it is in the proper Excel "Date" type, and is right justified in the Excel Cell.
In the code, we have
setDateFormat("MM/dd/yyyy");, so the Excel looks correct. It is purely the Excel column type that is the problem.BTW, using version 1.0.1 for a Vaadin 7 application.
I attached the screen I am exporting, with a date column, and the corresponding excel export, to explain what I mean.
exported-excel-20211015155230.xls