[TIME-40] date formats not properly accepted in Excel

[Andriy Zhdanov]

First of all, thanks for writing this useful plug-in. The developers in our team make use of it every day.
Still there is an imperfection to it concerning the Excel export.
When I perform a Time Sheet Report and export it to Excel, the date formats are not consistent; it even puts the wrong date:
6/30/08 (while this should be 2008-06-30)
2007-01-08 (while this should be 2008-07-01; it seems that it doesn't understand the yyyy-MM-dd format)

In Look and Feel, I had put all date formats on yyyy-MM-dd.
Yesterday, I also put the Date Picker on the same format in jira-application.properties.
Maybe the reason is, that these dates where badly formatted because of the different format of Date Picker at that time?
How do I solve this?

By sabine.vanregenmortel/Sabine Van Regenmortel on Tue, 8 Jul 2008 03:20:25 -0700

[Andriy Zhdanov]

In the Excel file, different formats are used within one issue. I can live with it if the format is not the desired one, but the yyyy-mm-dd format results in a completely wrong date: mmmm-dd-yy. At least I would expect it to be the correct date, and secondly to be formatted consistently within the Excel file.

By sabine.vanregenmortel on Tue, 8 Jul 2008 03:25:01 -0700

[Andriy Zhdanov]

Hi Sabine,

Thank you for detailed description, the problem is clear, plugin uses default date format for Jira locale, but it does not correspond to date format you specifiy in the properties, more over, it does not correspond to your local machine locale, thus, even though it is consistent (you may see ConfigureReport!excelView.jspa), Excel incorrectly guesses the date on your machine, according to your system settings.

I think it is good idea to make plugin to use Date Picker date format from jira-application.properties for excel reports.

Committed revision 21072, 21073, 21074: use outlookDate.formDatePicker to format date for excel reports

Please update your .jar.

By azhdanov on Tue, 15 Jul 2008 10:47:29 -0700

[Andriy Zhdanov]

Thank you, Andrew for this quick action. I downloaded it properly now (...) and it works fine!
Closing this issue...

By sabine.vanregenmortel on Fri, 18 Jul 2008 11:40:08 -0700