-
Bug
-
Resolution: Duplicate
-
Low
-
None
-
None
-
None
-
Severity 3 - Minor
Issue Summary
Jira Spreadsheets export producing incorrect dates/times
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
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.
- duplicates
-
API-272 Exporting issues using the Google Sheets/Excel integration will show dates in UTC
- Closed