Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-394

Jira Spreadsheets export producing incorrect dates/times

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • None
    • Jira Cloud for Excel
    • None
    • Severity 3 - Minor

      Issue Summary

      Jira Spreadsheets export producing incorrect dates/times

      Steps to Reproduce

      1. Perform a JQL search
      2. Click on the Open in Microsoft Excel icon.
      3. When presented with the Select your Excel product popup, click Excel on Desktop. This will download the file to your desktop.
      4. Open the file with Microsoft Excel or MacOS Numbers

      Expected Results

      • The dates/time should be displayed as that on your Jira Cloud settings

      Actual Results

      • The dates/times are shown in UTC format

      Workaround

      • Determine your timezone, say UTC+11
      • In Excel, let's say cell A2 has the time in UTC. Add a new cell with the formula:
        =A2 + TIME(11,0,0)

        where the 11 is the positive offset from UTC.

              Unassigned Unassigned
              kpillai KP
              Votes:
              5 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: