Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
Windows 2003
-
9
-
48
-
Description
NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.
Hi everyone,
Thanks for voting and commenting on this issue. Your feedback is key to helping us understand how you use JIRA so we can continue improving your experience. We have reviewed this issue over the last few days; unfortunately we don't have any plans to support this in JIRA for the foreseeable future.
Please remember that jira.atlassian.com is one of many inputs for the JIRA roadmap. You can learn more about our process here.
I understand that our decision may be disappointing. Please don't hesitate to contact me if you have any questions.
Regards,
Dave Meyer
dmeyer@atlassian.com
Product Manager, JIRA Platform
The Original Estimate field, which in JIRA is displayed as 1 day, 2 days, 2 weeks, etc. is converted to seconds per 7-hour day when it reaches Excel. For example, a task that is 1 day in JIRA appears as 25200 in Excel.
I see a bug where this was done in order to implement sorting of time, but is there a way to switch this back to preserve the original date formatting - we don't need to sort by second and we would like to not have to manually reconvert back to dates.
Attachments
Issue Links
- is caused by
-
JRASERVER-7438 "Current Fields" excel view of time-related fields is really bad for any post-processing in excel
- Closed
- is duplicated by
-
JRASERVER-23619 Time Tracking converted to seconds on export tickets to Excel
- Closed
-
JRASERVER-27675 Make it possible to choose base unit of time for excel exports
- Closed
- is related to
-
JRASERVER-26580 Issue Navigator Excel export change time to seconds format
- Gathering Impact
- relates to
-
JRASERVER-66524 Test
- Closed
-
JRACLOUD-8898 Original Estimate field's Excel export format should be configurable
- Gathering Interest