Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-199

Excel: Using the JIRA() function to re-import does not clear out old data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 2 - Major

      Issue Summary

      Question from: https://community.atlassian.com/t5/Jira-articles/The-add-in-you-ve-been-waiting-for-Jira-Cloud-for-Excel/ba-p/1210420

      Using the JIRA() function to re-import does not clear out old data, causing incorrect reports. Ex) If a data pull retrieves 50 rows, and the next data pull retrieves 40 rows, the report shows 50 rows: The most recent 40, plus the last 10 of the previous pull. Perhaps it could clear rows based on the row bound parameter provided.

      Steps to Reproduce

      ...

      Expected Results

      ...

      Actual Results

      ... 

      Workaround

      Delete the data manually...

            [API-199] Excel: Using the JIRA() function to re-import does not clear out old data

            Samyak Mehta made changes -
            Resolution New: Cannot Reproduce [ 5 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Vitalii Saienko (Inactive) made changes -
            Component/s New: Jira Cloud for Google Sheets [ 55791 ]
            Component/s Original: Jira Cloud for Sheets [ 56590 ]
            Catherine Chang (Inactive) made changes -
            Assignee New: Catherine Chang [ cchang@atlassian.com ]
            Tanguy Crusson made changes -
            Status Original: Needs Triage [ 10030 ] New: In Progress [ 3 ]
            Tanguy Crusson created issue -

              cchang@atlassian.com Catherine Chang (Inactive)
              tcrusson Tanguy Crusson
              Affected customers:
              1 This affects my team
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: