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 added a comment -

            Hi all,

            This issue is not reproducible anymore. Please feel free to reach out to Atlassian Support if you face any concerns.

            Samyak Mehta added a comment - Hi all, This issue is not reproducible anymore. Please feel free to reach out to Atlassian Support if you face any concerns.

            Levente Szabo [Midori] added a comment - - edited

            Hi Craig,

            This issue has been transitioned to "In progress" 2 years ago and it has an Inactivated user as Assignee and no updates from Atlassian. Based on experience, it's fair to say this has been abandoned and whether they will ever pick this up is hard to say. Especially, because currently there is 1 vote on it, which is an important metric.

            I'm part of a team at Midori working on a new Excel exporter app. If solving this issue is business-critical for you and you are open to more professional options (e.g.: a dedicated, native Jira Cloud app instead of a MS Excel add-in), I recommend you discover what the recently released Better Excel Exporter Cloud can do for you and your team! You can also read more here or watch a short tutorial.

            Levente Szabo [Midori] added a comment - - edited Hi Craig, This issue has been transitioned to "In progress" 2 years ago and it has an Inactivated user as Assignee and no updates from Atlassian. Based on experience, it's fair to say this has been abandoned and whether they will ever pick this up is hard to say. Especially, because currently there is 1 vote on it, which is an important metric. I'm part of a team at Midori working on a new Excel exporter app. If solving this issue is business-critical for you and you are open to more professional options (e.g.: a dedicated, native Jira Cloud app instead of a MS Excel add-in), I recommend you discover what the recently released Better Excel Exporter Cloud can do for you and your team! You can also read more here or watch a short tutorial .

            Craig Cinder added a comment -

            Any updates on this fix? 

            Craig Cinder added a comment - Any updates on this fix? 

              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: