Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-149

SLA values are incorrect when exported into Excel

    XMLWordPrintable

Details

    Description

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

      Summary of Bug

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

      Steps to reproduce

      1. Create a Service Desk issue, and leave it for a few days (works best this way)
      2. 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
      3. 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 :

      Attachments

        1. SLA 2.png
          SLA 2.png
          114 kB
        2. SLA 1.png
          SLA 1.png
          51 kB
        3. SLA 3.png
          SLA 3.png
          62 kB
        4. SLA.jpg
          SLA.jpg
          196 kB
        5. SLA.jpg
          SLA.jpg
          196 kB
        6. SLA_BUG.png
          SLA_BUG.png
          458 kB
        7. sla-in-libre-office.png
          sla-in-libre-office.png
          159 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-640 jira service desk: bug in reporting when exporting SLA's into excel

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-1174 Bug with Exporting SLA data to Excel

          • Low - Low priority issues
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-581 Service Desk SLA Custom Field values doesn't show in XML format

          • Low - Low priority issues
          • Closed

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

          • Gathering Interest
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JSDCLOUD-149 SLA values are incorrect when exported into Excel

          • Low - Low priority issues
          • Closed

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

          • Gathering Interest
          mentioned in

          Page Loading...

          was cloned as

          DESK-2390 Loading...

          Activity

            People

              knguyen@atlassian.com Kha Nguyen (Inactive)
              jtye Joe Wai Tye (Inactive)
              Votes:
              32 Vote for this issue
              Watchers:
              44 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync