Loading...

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 7.2.2, Available in Jira Cloud
Affects Version/s: 7.2.0, Archived Jira Cloud
Component/s: Navigation - Export
Labels:

Introduced in Version:
7.02
Symptom Severity:
Severity 3 - Minor
Bug Fix Policy:
View Atlassian Server bug fix policy

NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

Atlassian Update: 27nd September 2016

Hi Everyone,

This issue is fixed in Both JIRA Cloud and JIRA Server.

JIRA Cloud users have already got their instances updated.
JIRA Server users have to upgrade to JIRA 7.2.2 Server which is now available to download at https://www.atlassian.com/download .

Thanks,
Ignat Alexeyenko
JIRA Bugmaster.

Summary

When using the Excel (CSV, Current Fields) Export option, column order does not match what was selected in the WebUI and the Issue ID field is included (though it was not selected).

Environment

JIRA v1000.25.1 Cloud

Steps to Reproduce

Perform a JIRA Issue Search
Configure custom Columns and Column Order
Export Issues to CSV using Export > Excel (CSV, Current Fields)

Expected Results

Downloaded CSV file only shows Columns (and results) based on what is selected in the WebUI

Actual Results

No Errors in logs.
The IssueID field (column) is added
Order does not keep to what was configured in the WebUI
Shown in screenshot:

WebUI	Issue Type, Issue Key, Summary, Assignee, Reporter, Priority, Status, Resolution, Created Date, Updated Date, Affects Version/s, Links
CSV Export	Summary, Issue Key, Issue id, Issue Type, Status, Priority, Resolution, Assignee, Reporter, Created, Updated, Outward issue link (Blocks)

Notes

Appears that the Excel (CSV) Export options were added in April 19th but listed as a Service Desk Feature: https://confluence.atlassian.com/display/Cloud/What's+New#What'sNew-servicedesk

Workaround

As a workaround you can use the Export HTML Report (current field/all fields). You can then edit the name of the file from <filename>.html to <filename>.xls and it should open up in your spreadsheet program. You may run into this bug: https://jira.atlassian.com/browse/JRA-61891

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

WebvsCSV.png
317 kB
31/May/2016 10:04 PM
screenshot-1.png
40 kB
06/Sep/2016 6:59 PM
screenshot-2.png
41 kB
07/Sep/2016 2:54 PM
FilterColumnsInJIRASoftware_7.2.5.png
42 kB
22/Dec/2016 5:08 PM

is duplicated by

JRASERVER-62679 Export CSV/HTML with Current Fields not a CSV/HTML representation of Filter Results

Gathering Impact

is related to

JRASERVER-61891 Search results exported to Excel result in empty sheets due to Microsoft security update

Closed

JRASERVER-62217 Export (CSV, All Fields) and Export (CSV, Current Fields) Issue link value shows in multiple column

Closed

JRASERVER-62115 Provide your feedback on new CSV export functionality in Jira 7.4

Closed

JRASERVER-62216 Export (CSV, All Fields) and Export (CSV, Current Fields) shows the heading as 'Custom field (<field name>)'

Gathering Interest

relates to

JRACLOUD-61244 Export to Excel CSV Current Fields Does Not Show Same Order as WebUI

Closed

JRASERVER-32352 Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers

Closed

JRASERVER-62366 Export to Excel CSV is displaying username instead of full names

Closed

mentioned in: Page Loading...; Page Loading...; Page Loading...

was cloned as: NEXT-1118 Loading...; JSB-96 Loading...

(3 relates to, 3 mentioned in, 2 was cloned as)

Assignee:: Unassigned

Reporter:: Shawn C

Votes:: 14 Vote for this issue

Watchers:: 51 Start watching this issue

Created:: 31/May/2016 10:04 PM

Updated:: 09/May/2019 4:33 AM

Resolved:: 30/Aug/2016 6:11 AM

Details

Description

Summary

Environment

Steps to Reproduce

Expected Results

Actual Results

Notes

Workaround

Attachments

Attachments

Issue Links

Forms

Activity

People

Dates