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

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • None
    • Affects Version/s: 1.0
    • Component/s: Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor

      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.

            Assignee:
            Mykyta Koptsov (Inactive)
            Reporter:
            Eduardo Santos (Inactive)
            Votes:
            54 Vote for this issue
            Watchers:
            56 Start watching this issue

              Created:
              Updated:
              Resolved: