[JSDCLOUD-149] SLA values are incorrect when exported into Excel - Create and track feature requests for Atlassian products.

XML

Word

Printable

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

Some issue records, especially with high SLA values show incorrectly when exported to Microsoft Excel.

Create a Service Desk issue, and leave it for a few days (works best this way)
In the Issue Navigator, add the 'Time to resolution' and 'Time waiting for support' fields. Search for the Service Desk issue, and take note of the values of those fields
Export the search results into Excel (tested with 'Current Fields'), and check the value for those fields.

The original value is supposed to be :

But in Excel it is shown as :

is duplicated by

JSDCLOUD-1174 Bug with Exporting SLA data to Excel

JSDCLOUD-640 jira service desk: bug in reporting when exporting SLA's into excel

is related to

JSDCLOUD-581 Service Desk SLA Custom Field values doesn't show in XML format

JSDCLOUD-9455 Service Desk SLA Custom Field values are excluded in XML format

JSDSERVER-149 SLA values are incorrect when exported into Excel

JSDCLOUD-78 Ability to view Elapsed Time as a column in Issue Navigator or in Export

relates to

JSDCLOUD-361 Service Desk SLA fields must appear in the exported formats

(1 is related to, 1 relates to)