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

Bug with Exporting SLA data to Excel

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • None
    • SLA
    • None

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

      Hi,

      We have purchased the Service Desk add-on and setup SLAs for incidents. When I export to Excel, it seems to be reversing the minutes and hours. In other words, in the Excel export, it is displaying mm:hh instead of hh:mm in the cells. It occurs for some of the breached SLAs, i.e. where there is a negative time, but not for all of them.

      Theo

      Tel. 0458 483 711

        1. Capture1.JPG
          Capture1.JPG
          14 kB
        2. export to excel - cell.JPG
          export to excel - cell.JPG
          10 kB

          Form Name

            [JSDSERVER-1174] Bug with Exporting SLA data to Excel

            Owen made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2303995 ] New: JAC Bug Workflow v3 [ 3124901 ]
            Status Original: Done [ 10044 ] New: Closed [ 6 ]
            Owen made changes -
            Priority New: Low [ 4 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 2057957 ] New: JSD Bug Workflow v5 - TEMP [ 2303995 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2055421 ] New: JSD Bug Workflow v5 [ 2057957 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 1955171 ] New: JSD Bug Workflow v5 - TEMP [ 2055421 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v4 [ 1614761 ] New: JSD Bug Workflow v5 [ 1955171 ]
            jonah (Inactive) made changes -
            Description Original: Hi,

            We have purchased the Service Desk add-on and setup SLAs for incidents. When I export to Excel, it seems to be reversing the minutes and hours. In other words, in the Excel export, it is displaying mm:hh instead of hh:mm in the cells. It occurs for some of the breached SLAs, i.e. where there is a negative time, but not for all of them.

            Theo

            Tel. 0458 483 711
            		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-1174].
              {panel}

            Hi,

            We have purchased the Service Desk add-on and setup SLAs for incidents. When I export to Excel, it seems to be reversing the minutes and hours. In other words, in the Excel export, it is displaying mm:hh instead of hh:mm in the cells. It occurs for some of the breached SLAs, i.e. where there is a negative time, but not for all of them.

            Theo

            Tel. 0458 483 711
            jonah (Inactive) made changes -
            Link New: This issue relates to JSDCLOUD-1174 [ JSDCLOUD-1174 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v2 [ 1602020 ] New: JSD Bug Workflow v4 [ 1614761 ]
            Owen made changes -
            Workflow Original: JSD Bug Workflow [ 1398152 ] New: JSD Bug Workflow v2 [ 1602020 ]

              Unassigned Unassigned
              theo.rangiah Theo Rangiah
              Affected customers:
              0 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: