-
Bug
-
Resolution: Not a bug
-
Medium
-
None
-
7.0.2, 7.1.1, 7.2.0
-
7
-
15
-
Severity 2 - Major
-
377
-
-
Summary
Having a comma in a text field will put values in wrong fields on a CSV exported from JIRA
Environment
JIRA server 7.1.x
JIRA server 7.2.x
Steps to Reproduce
- Create a new issue
- Put a comma in any place among the text in the Description field or any other text field
- From the issue navigator, export the issue to a CSV file (e.g. Export > CSV (All fields))
Expected Results
The CSV file will be created with the correct values for every field
Actual Results
Values after the comma will be exported to the wrong field in the CSV file, putting every field values after that in the wrong column in the CSV file
Workaround
Certain Microsoft Excel configurations does not correctly handle JIRA CSV export format. This typically depends on the region where product is installed.
To workaround the problem, one can use the Export to HTML feature that is available in JIRA 7.4.0 and latter.
Step 1. Export the data to HTML from JIRA
Step 2. Import the file into Excel.
Following options are available:
- Import Menu available in Microsoft Excel, chose the .html file exported from JIRA.
- Rename the exported file to .xls extension so it can be opened as ab Excel spreadsheet.
- is related to
-
JRASERVER-62115 Provide your feedback on new CSV export functionality in Jira 7.4
- Closed
-
JRASERVER-63747 Possibility to export multi-select fields of issue into single column in CSV
- Gathering Interest
-
GHS-68028 Loading...
- relates to
-
JRASERVER-63857 Can't open exported CSV in Microsoft Excel
- Closed
-
RAID-366 Loading...
-
RAID-634 Loading...
- was cloned as
-
RAID-120 Loading...