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

Jira Cloud Excel Export fails to distinguish between custom fields with duplicate names

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Jira Cloud for Excel
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Issue Summary

      When opening a Jira Issue Filter (a list of Jira issues) in Microsoft Excel using the "Open in Microsoft Excel" feature, if there are multiple custom fields with the same name, only one field is exported. This can result in empty columns in the export, even though the fields contain values in Jira.

      Steps to Reproduce

      1. Create a custom field called "Excel Options" (Select List - Single Choice) and add one option.
      1. Create another custom field with the same name and add one option.
      1. Create a third custom field with the same name and add three options.
      1. Associate the third custom field with a project's screens and create issues using these options.
      1. In Work Item search for this project, add the custom field as a column.
      1. Notice that multiple rows appear for each work item.
      1. Use Apps > Open in Microsoft Excel and observe that the column for this custom field is empty.

      Expected Results

      Each custom field with the same name should be exported to a separate column, ensuring all values are included in the export.

      Actual Results

      Only one value is exported, and the column may appear empty even when data exists.

      Workaround

      Users can use the Export > Export Excel CSV option as an alternative.

              mbamba@atlassian.com mbamba
              7372af706f9d Ariel (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: