-
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
-
[API-394] Jira Spreadsheets export producing incorrect dates/times
Resolution | New: Duplicate [ 3 ] | |
Status | Original: Needs Triage [ 10030 ] | New: Closed [ 6 ] |
Component/s | New: Jira Cloud for Excel [ 60090 ] | |
Component/s | Original: Ecosystem [ 53294 ] | |
Key |
Original:
|
New:
|
Affects Version/s | New: None [ 92938 ] | |
Project | Original: Jira Cloud (including JIRA Core) [ 18514 ] | New: Atlassian Product Integrations [ 20010 ] |
Security | Original: Atlassian Staff [ 10750 ] |
Description |
Original:
h3. Issue Summary
Jira Spreadsheets export producing incorrect dates/times h3. 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 h3. Expected Results * The dates/time should be displayed as that on your Jira Cloud settings h3. Actual Results * The dates/times are shown in UTC format h3. 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: {code:java} =A2 + TIME(11,0,0){code} where the *11* is the positive offset from UTC. |
New:
h3. Issue Summary
Jira Spreadsheets export producing incorrect dates/times h3. Steps to Reproduce # Perform a JQL search # Click on the _Open in Microsoft Excel_ icon. !2021-03-08_15-49-39.png|thumbnail! # 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 h3. Expected Results * The dates/time should be displayed as that on your Jira Cloud settings h3. Actual Results * The dates/times are shown in UTC format h3. 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: {code:java} =A2 + TIME(11,0,0){code} where the *11* is the positive offset from UTC. |
Attachment | New: 2021-03-08_15-49-39.png [ 400601 ] |
Description |
Original:
h3. Issue Summary
Jira Spreadsheets export producing incorrect dates/times h3. 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 h3. Expected Results * The dates/time should be displayed as that on your Jira Cloud settings h3. Actual Results * The dates/times are shown in UTC format h3. 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 postive offset from UTC. |
New:
h3. Issue Summary
Jira Spreadsheets export producing incorrect dates/times h3. 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 h3. Expected Results * The dates/time should be displayed as that on your Jira Cloud settings h3. Actual Results * The dates/times are shown in UTC format h3. 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: {code:java} =A2 + TIME(11,0,0){code} where the *11* is the positive offset from UTC. |