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
          458 kB
          Julio Franjola
        2. SLA.jpg
          196 kB
          Ankur Mehrotra
        3. SLA.jpg
          196 kB
          Ankur Mehrotra
        4. SLA 1.png
          51 kB
          Joe Wai Tye
        5. SLA 2.png
          114 kB
          Joe Wai Tye
        6. SLA 3.png
          62 kB
          Joe Wai Tye
        7. sla-in-libre-office.png
          159 kB
          Midori

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

            Hi,

             

            I still face the same issue on jsd 4.10.13 .. 

             

             

            Gülçin Nacak added a comment - Hi,   I still face the same issue on jsd 4.10.13 ..     

            Mizan added a comment -

            Dear Atlassian,

            I still face the same issue on Jira 8.4.1 with JSD 4.4.1 .

             

            Kindly confirm and re-open this request

            Mizan added a comment - Dear Atlassian, I still face the same issue on Jira 8.4.1 with JSD 4.4.1 .   Kindly confirm and re-open this request
            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

              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: