-
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
[API-663] Jira Cloud for Excel add-in only fetches 1000 records or fails with error when the sheet is heavily utilized
| Workflow | Original: JAC Bug Workflow v3 [ 4381603 ] | New: JAC Bug Workflow v4 [ 4567421 ] |
| Description |
Original:
h3. 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 h3. 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 h3. Expected Results All the results from the JQL should be loaded into the sheet h3. 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 ; {code:java} Oops... Something went wrong. Try importing again{code} h3. Workaround * 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|https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4#ID0EBBF=Web] |
New:
h3. 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 h3. 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 h3. Expected Results All the results from the JQL should be loaded into the sheet h3. 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 ; {code:java} Oops... Something went wrong. Try importing again{code} h3. 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|https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4#ID0EBBF=Web] * For export to Excel * Try to export lesser rows using your filter |
| Description |
Original:
h3. 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. h3. 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 h3. Expected Results All the results from the JQL should be loaded into the sheet h3. 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 ; {code:java} Oops... Something went wrong. Try importing again{code} h3. Workaround * 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|https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4#ID0EBBF=Web] |
New:
h3. 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 h3. 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 h3. Expected Results All the results from the JQL should be loaded into the sheet h3. 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 ; {code:java} Oops... Something went wrong. Try importing again{code} h3. Workaround * 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|https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4#ID0EBBF=Web] |
| Summary | Original: Jira Cloud for Excel add-in only fetches 1000 records when the sheet is heavily utilized | New: Jira Cloud for Excel add-in only fetches 1000 records or fails with error when the sheet is heavily utilized |
| Status | Original: Needs Triage [ 10030 ] | New: Gathering Impact [ 12072 ] |
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).