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

Exporting using Excel export doesn't follow the Personal settings time zone , but it display with UTC timezone

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Duplicate
    • None
    • Jira Cloud for Excel
    • None

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Issue Summary

      When user export using Excel export feature, the date/time field doesn't follow the personal settings time zone , but it display with UTC timezone.

      Steps to Reproduce

      1. Go to Personal Settings, change the timezone, for example, Sydney timezone.
      2. Go to Issue Navigator page and filter the issue would like to export
      3. Then, click the Excel button to export it:-
      4. Check the Created field

      Expected Results

      The created date display with Sydney timezone , which is the same as display in JIRA.

      Actual Results

      The created date time display with UTC timezone

      Workaround

      Export using CSV format and open via Excel.

        1. Screen Shot 2021-02-02 at 1.14.56 pm.png
          47 kB
          Atiqah Roslan

            [API-378] Exporting using Excel export doesn't follow the Personal settings time zone , but it display with UTC timezone

            Vitalii Saienko (Inactive) added a comment -

            Please follow this ticket for updates https://jira.atlassian.com/browse/API-272

            Vitalii Saienko (Inactive) added a comment - Please follow this ticket for updates https://jira.atlassian.com/browse/API-272

              odanchenko Olexandr Danchenko (Inactive)
              nroslan Atiqah Roslan
              Votes:
              5 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: