Issue Summary

• Attempting to load issues using the add-in takes an excessively long time and incorrectly states that all the issues have been loaded when an Excel spreadsheet is heavily utilized with a lot of lookup functions and calculations.
• If there are more than 1000 results returned by the JQL query, the add-in incorrectly states that all issues have been loaded despite only loading 1000 issues.
• Trying to export more than 1000 rows from Jira issue-navigator to MS Excel

Steps to Reproduce

1. Create a heavily utilized Excel spreadsheet with a lot of lookup functions, calculations and links to other sheets/workbooks
2. Load the Jira Cloud for Excel add-in and fetch issues from a JQL query that contains more than 1000 results

Expected Results

All the results from the JQL should be loaded into the sheet

Actual Results

• Only 1000 results from the JQL are loaded, however, this takes a significantly long time to load. The time taken to load gives the impression that the import function is not working.
• Sometimes, the following error message is displayed ;

  Oops... Something went wrong. Try importing again

Workaround

• For Add-in
  • Try to load the JQL issues in a new worksheet which is not heavily utilized
  • Change the Excel calculation method to Manual from Automatic as described in Change formula recalculation, iteration, or precision in Excel
• For export to Excel
• Try to export lesser rows using your filter