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

  None

[API-539] "State mismatch" while using "Open in Sheets" functionality

Collapse comment: Henrique Peres de Freitas added a comment - 06/Oct/2023 12:47 PM

Henrique Peres de Freitas added a comment - 06/Oct/2023 12:47 PM

Same issue here ant this solutions is not solving nothing. how hard is to create an export to excel button that works?

Expand comment: Henrique Peres de Freitas added a comment - 06/Oct/2023 12:47 PM

Henrique Peres de Freitas added a comment - 06/Oct/2023 12:47 PM Same issue here ant this solutions is not solving nothing. how hard is to create an export to excel button that works?

Collapse comment: Gustavo Nunes Batista added a comment - 06/Sep/2023 9:40 AM

Gustavo Nunes Batista added a comment - 06/Sep/2023 9:40 AM

Hey guys,

This is also affecting some of our users. 

Expand comment: Gustavo Nunes Batista added a comment - 06/Sep/2023 9:40 AM

Gustavo Nunes Batista added a comment - 06/Sep/2023 9:40 AM Hey guys, This is also affecting some of our users. 

Collapse comment: Hubert Hof added a comment - 17/Jul/2023 6:48 AM

Hubert Hof added a comment - 17/Jul/2023 6:48 AM

When will this be fixed? 

Expand comment: Hubert Hof added a comment - 17/Jul/2023 6:48 AM

Hubert Hof added a comment - 17/Jul/2023 6:48 AM When will this be fixed? 

Collapse comment: Katarzyna Rowinska added a comment - 10/Feb/2023 9:46 AM

Katarzyna Rowinska added a comment - 10/Feb/2023 9:46 AM

the workaround worked for me: First I closed all then disabled the popup blocker for the site and installing Jira Cloud Sheet app.

Expand comment: Katarzyna Rowinska added a comment - 10/Feb/2023 9:46 AM

Katarzyna Rowinska added a comment - 10/Feb/2023 9:46 AM the workaround worked for me: First I closed all then disabled the popup blocker for the site and installing Jira Cloud Sheet app.

Collapse comment: Adeline Delfieu added a comment - 10/Nov/2022 8:24 AM

Adeline Delfieu added a comment - 10/Nov/2022 8:24 AM

I found the issue, I was missing a step in accessing Jira from excel (my fault). IT works fine now

Expand comment: Adeline Delfieu added a comment - 10/Nov/2022 8:24 AM

Adeline Delfieu added a comment - 10/Nov/2022 8:24 AM I found the issue, I was missing a step in accessing Jira from excel (my fault). IT works fine now

Collapse comment: tyroneb added a comment - 10/Nov/2022 6:14 AM

tyroneb added a comment - 10/Nov/2022 6:14 AM

I ran into this issue and did the below:

• Followed the workaround mentioned above, that did not work
• I then close the browser tab as well as close excel altogether
• I then reopened excel and tried to connect again and still got the error
• Tried the workaround again and this time it connected

Perhaps this might help someone else. It seems you just need to keep trying until it works.

Expand comment: tyroneb added a comment - 10/Nov/2022 6:14 AM

tyroneb added a comment - 10/Nov/2022 6:14 AM I ran into this issue and did the below: Followed the workaround mentioned above, that did not work I then close the browser tab as well as close excel altogether I then reopened excel and tried to connect again and still got the error Tried the workaround again and this time it connected Perhaps this might help someone else. It seems you just need to keep trying until it works.

Collapse comment: Adeline Delfieu added a comment - 21/Oct/2022 9:33 AM

Adeline Delfieu added a comment - 21/Oct/2022 9:33 AM

the solution provided is not working

Expand comment: Adeline Delfieu added a comment - 21/Oct/2022 9:33 AM

Adeline Delfieu added a comment - 21/Oct/2022 9:33 AM the solution provided is not working

Vitalii Saienko (Inactive) made changes - 10/May/2022 5:24 PM

Description

Original: h3. Issue Summary While using the "Open in Excel" or "Open in Sheets" buttons, it asks to authorize into Microsoft or Google and then asks to authorize in Jira and after that it shows a "State mismatch" error. h3. Steps to Reproduce  # Open advanced issue search page  # Click the "Open in Sheets" button  # Follow authorization prompts  # In the end it will show "State mismatch" error h3. Expected Results It should allow exporting data to Excel or Sheets and authorization should work h3. Actual Results State mismatch error h3. Workaround If you get a "State mismatch" error, close the window with the error, close the dialog the verification code, wait 30-40 seconds and then try again. You can also use a standalone [Jira Cloud for Excell add-in|https://appsource.microsoft.com/en-us/product/office/WA200000556] or [Jira Cloud for Sheets app|https://workspace.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016]. Also, you can use a Jira natvie export.

New: h3. Issue Summary While using the "Open in Sheets" buttons, it asks to authorize into Microsoft or Google and then asks to authorize in Jira and after that, it shows a "State mismatch" error. h3. Steps to Reproduce  # Open advanced issue search page  # Click the "Open in Sheets" button  # Follow authorization prompts  # In the end, it will show a "State mismatch" error h3. Expected Results It should allow exporting data to Excel or Sheets and authorization should work h3. Actual Results State mismatch error h3. Workaround If you get a "State mismatch" error, close the window with the error, close the dialog the verification code, wait 30-40 seconds and then try again. You can also use a standalone [Jira Cloud for Sheets app|https://workspace.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016]. Also, you can use a Jira native export.

Vitalii Saienko (Inactive) made changes - 10/May/2022 5:24 PM

Summary

Original: "State mismatch" while using "Open in Excel/Sheets" functionality

New: "State mismatch" while using "Open in Sheets" functionality

Vitalii Saienko (Inactive) made changes - 09/May/2022 4:07 PM

Status

Original: Needs Triage [ 10030 ]

New: Gathering Impact [ 12072 ]

Load more older events