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 :

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

            [JSDSERVER-149] SLA values are incorrect when exported into Excel

            Owen made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2305122 ] New: JAC Bug Workflow v3 [ 3126100 ]
            Status Original: Done [ 10044 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 2059049 ] New: JSD Bug Workflow v5 - TEMP [ 2305122 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2056441 ] New: JSD Bug Workflow v5 [ 2059049 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 1956001 ] New: JSD Bug Workflow v5 - TEMP [ 2056441 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v4 [ 1615290 ] New: JSD Bug Workflow v5 [ 1956001 ]
            jonah (Inactive) made changes -
            Description Original: h3. Summary of Bug

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

            h3. Steps to reproduce

            # 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 :
            !SLA 3.png|thumbnail!

            But in Excel it is shown as :
            !SLA 2.png|thumbnail!
            New: {panel:bgColor=#e7f4fa}
              *NOTE:* This bug report is for *JIRA Service Desk Server*. Using *JIRA Service Desk Cloud*? [See the corresponding bug report|http://jira.atlassian.com/browse/JSDCLOUD-149].
              {panel}

            h3. Summary of Bug

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

            h3. Steps to reproduce

            # 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 :
            !SLA 3.png|thumbnail!

            But in Excel it is shown as :
            !SLA 2.png|thumbnail!
            jonah (Inactive) made changes -
            Link New: This issue relates to JSDCLOUD-149 [ JSDCLOUD-149 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels Original: affects-cloud mfd rv New: affects-cloud affects-server mfd rv
            Confluence Escalation Bot (Inactive) made changes -
            Labels Original: mfd rv New: affects-cloud mfd rv
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v2 [ 1602615 ] New: JSD Bug Workflow v4 [ 1615290 ]

              knguyen@atlassian.com Kha Nguyen (Inactive)
              jtye Joe Wai Tye (Inactive)
              Affected customers:
              32 This affects my team
              Watchers:
              44 Start watching this issue

                Created:
                Updated:
                Resolved: