• 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.

            [API-394] Jira Spreadsheets export producing incorrect dates/times

            Leonardo De Almeida made changes -
            Link New: This issue duplicates API-272 [ API-272 ]
            Leonardo De Almeida made changes -
            Resolution New: Duplicate [ 3 ]
            Status Original: Needs Triage [ 10030 ] New: Closed [ 6 ]
            Beata Szturemska made changes -
            Component/s New: Jira Cloud for Excel [ 60090 ]
            Component/s Original: Ecosystem [ 53294 ]
            Key Original: JRACLOUD-76150 New: API-394
            Affects Version/s New: None [ 92938 ]
            Project Original: Jira Cloud (including JIRA Core) [ 18514 ] New: Atlassian Product Integrations [ 20010 ]
            KP made changes -
            Security Original: Atlassian Staff [ 10750 ]
            KP made changes -
            Description Original: h3. Issue Summary

            Jira Spreadsheets export producing incorrect dates/times
            h3. Steps to Reproduce
             # Perform a JQL search
             # Click on the _Open in Microsoft Excel_ icon.
             # When presented with the _Select your Excel product_ popup, click _Excel on Desktop_. This will download the file to your desktop.
             # Open the file with Microsoft Excel or MacOS Numbers

            h3. Expected Results
             * The dates/time should be displayed as that on your Jira Cloud settings

            h3. Actual Results
             * The dates/times are shown in UTC format

            h3. 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:
            {code:java}
            =A2 + TIME(11,0,0){code}
            where the *11* is the positive offset from UTC.
            New: h3. Issue Summary

            Jira Spreadsheets export producing incorrect dates/times
            h3. Steps to Reproduce
             # Perform a JQL search
             # Click on the _Open in Microsoft Excel_ icon.
             !2021-03-08_15-49-39.png|thumbnail!
             # When presented with the _Select your Excel product_ popup, click _Excel on Desktop_. This will download the file to your desktop.
             # Open the file with Microsoft Excel or MacOS Numbers

            h3. Expected Results
             * The dates/time should be displayed as that on your Jira Cloud settings

            h3. Actual Results
             * The dates/times are shown in UTC format

            h3. 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:
            {code:java}
            =A2 + TIME(11,0,0){code}
            where the *11* is the positive offset from UTC.
            KP made changes -
            Attachment New: 2021-03-08_15-49-39.png [ 400601 ]
            KP made changes -
            Description Original: h3. Issue Summary
            Jira Spreadsheets export producing incorrect dates/times

            h3. Steps to Reproduce
             # Perform a JQL search
             # Click on the _Open in Microsoft Excel_ icon.
             # When presented with the _Select your Excel product_ popup, click _Excel on Desktop_. This will download the file to your desktop.
             # Open the file with Microsoft Excel or MacOS Numbers

            h3. Expected Results
            * The dates/time should be displayed as that on your Jira Cloud settings

            h3. Actual Results
            * The dates/times are shown in UTC format

            h3. 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 postive offset from UTC.
            New: h3. Issue Summary

            Jira Spreadsheets export producing incorrect dates/times
            h3. Steps to Reproduce
             # Perform a JQL search
             # Click on the _Open in Microsoft Excel_ icon.
             # When presented with the _Select your Excel product_ popup, click _Excel on Desktop_. This will download the file to your desktop.
             # Open the file with Microsoft Excel or MacOS Numbers

            h3. Expected Results
             * The dates/time should be displayed as that on your Jira Cloud settings

            h3. Actual Results
             * The dates/times are shown in UTC format

            h3. 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:
            {code:java}
            =A2 + TIME(11,0,0){code}
            where the *11* is the positive offset from UTC.
            KP created issue -

              Unassigned Unassigned
              kpillai KP
              Affected customers:
              5 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: