-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
1.0
-
None
-
Severity 3 - Minor
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
- Create a heavily utilized Excel spreadsheet with a lot of lookup functions, calculations and links to other sheets/workbooks
- 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
This appears to be caused by a conflict between the add-in and the Excel auto-calculation.
I suggest this be given a higher priority given use of the add-in is already a workaround for the fact that you can only export 1,000 records at a time from Jira (and if you do it in multiple tranches of 1,000 the columns don't align making it difficult to combine them).