Export to CSV formatting multiline text

XMLWordPrintable

    • Severity 3 - Minor

      Summary

      Export to csv uses both a carriage return and a linefeed for multiline data

      Steps to Reproduce

      1. Search for issues (which have multi-line data in some fields) in Issue Navigator
      2. Export to CSV all fields

      Expected Results

      Data is exported to CSV and can be viewed correctly in Excel.

      Actual Results

      Data is exported to CSV but does not render correctly in some versions of Excel

      Notes

      Two csv files attached.
      csv saved from excel.csv Export to CSV all fields JIRA

      The jira one uses both a carriage return and a linefeed which results in the file not loading correctly in Excel.
      However, if you create a simple file in Excel, include some data with a line break in it and then save it as a csv, you see that the line break within the data uses just a linefeed.

            Assignee:
            Unassigned
            Reporter:
            Vik
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: