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
          Screen Shot 2021-02-02 at 1.14.56 pm.png
          47 kB

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

            Vitalii Saienko (Inactive) made changes -
            Resolution New: Duplicate [ 3 ]
            Status Original: Gathering Interest [ 11772 ] New: Closed [ 6 ]

            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
            Vitalii Saienko (Inactive) made changes -
            Link New: This issue duplicates API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Link Original: This issue relates to API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Link Original: This issue duplicates API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Link New: This issue relates to API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Link Original: This issue is related to API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Link New: This issue duplicates API-272 [ API-272 ]
            Vitalii Saienko (Inactive) made changes -
            Affects Version/s Original: None [ 92938 ]
            Workflow Original: JAC Bug Workflow v3 [ 4056768 ] New: JAC Suggestion Workflow 3 [ 4070955 ]
            Issue Type Original: Bug [ 1 ] New: Suggestion [ 10000 ]
            Priority Original: Low [ 4 ]
            Status Original: Needs Triage [ 10030 ] New: Gathering Interest [ 11772 ]
            Vitalii Saienko (Inactive) made changes -
            Link Original: This issue relates to API-386 [ API-386 ]

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

                Created:
                Updated:
                Resolved: