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.

Steps to Reproduce

1. Open advanced issue search page
2. Click the "Open in Sheets" button
3. Follow authorization prompts
4. In the end, it will show a "State mismatch" error

Expected Results

It should allow exporting data to Excel or Sheets and authorization should work

Actual Results

State mismatch error

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. Also, you can use a Jira native export.