Loading...

XML

Word

Printable

NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

When I export search results to an excel. The values of Original Estimate and other time fields are converted to seconds.

For example, the value in JIRA should be 5h, but in excel, it's 18000 seconds. It should be the same as in Issue Navigator.

WORKAROUND (Copied from JRA-8898):

As a workaround, it should be possible to define a formula converting the seconds to whatever format is desired (this can then be sorted on too).

is duplicated by

JRASERVER-46293 Jira Export to xls changes format for columns related to Time( hours to seconds)

JRASERVER-23619 Time Tracking converted to seconds on export tickets to Excel

relates to

JRACLOUD-26580 Issue Navigator Excel export change time to seconds format

JRASERVER-8898 Original Estimate field's Excel export format should be configurable