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

Exporting issues using the Google Sheets/Excel integration will show dates in UTC

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • None
    • 1.0
    • None
    • Severity 3 - Minor

    Description

      Issue Summary

      Using the Jira Cloud for Sheets/Excel integration to export issues will show all the dates in UTC and not under the user profile timezone.

      Steps to Reproduce

      1. Access the issue navigator and build a JQL;
      2. Export the issues using the Jira Cloud for Sheets/Excel integration;
      3. Check the date and time fields.

      Expected Results

      The issues are exported using the user timezone.

      Actual Results

      The issues are exported using UTC instead of their own timezones.

      Workaround

      Workaround 1

      Export the issues using the Jira export functionality

      Workaround 2

      Import the issues by using the JQL method from the Excel's or Google Sheet side instead of opening the results from the Jira's issue search navigation view.

      Attachments

        Issue Links

          Activity

            People

              ac1d9a6a7e17 Mykyta Koptsov (Inactive)
              esantos@atlassian.com Eduardo Santos
              Votes:
              54 Vote for this issue
              Watchers:
              56 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: