• Type: Bug
• Resolution: Duplicate
• Priority: Low
• Fix Version/s: None
• Affects Version/s: None
• Component/s: Jira Cloud for Excel
• Labels:

  None

1. 

   2021-03-08_15-49-39.png

   261 kB

   08/Mar/2021 5:02 AM

[API-394] Jira Spreadsheets export producing incorrect dates/times

Leonardo De Almeida made changes - 23/Sep/2021 12:39 PM

Link

New: This issue duplicates API-272 [ API-272 ]

Leonardo De Almeida made changes - 23/Sep/2021 12:39 PM

Resolution		New: Duplicate [ 3 ]
Status	Original: Needs Triage [ 10030 ]	New: Closed [ 6 ]

Beata Szturemska made changes - 08/Mar/2021 12:37 PM

Component/s		New: Jira Cloud for Excel [ 60090 ]
Component/s	Original: Ecosystem [ 53294 ]
Key	Original: JRACLOUD-76150	New: API-394
Affects Version/s		New: None [ 92938 ]
Project	Original: Jira Cloud (including JIRA Core) [ 18514 ]	New: Atlassian Product Integrations [ 20010 ]

KP made changes - 08/Mar/2021 5:05 AM

Security

Original: Atlassian Staff [ 10750 ]

KP made changes - 08/Mar/2021 5:03 AM

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.

KP made changes - 08/Mar/2021 5:02 AM

Attachment

New: 2021-03-08_15-49-39.png [ 400601 ]

KP made changes - 08/Mar/2021 5:02 AM

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.

KP created issue - 08/Mar/2021 5:00 AM