Problem Definition

If we are using Multiline Text Fields, we can store more than 32,767 characters in the Field's value. When we export any issue in CSV format that has a Multiline Text Field with more than 32,767 characters stored in it, data is not exported properly, and the remaining characters of the Multiline Text field after the 32,767 characters are shifted to the Next line. Also, data for fields after the Multiline Text field is shifted to the next line in the CSV file.

Refer to the attached File Data_split_in_2_lines.csv where the custom Field (Multi_line) has more than 55k characters and data is split into 2 lines, while the data comes in a proper format in Data_in_Single_Line.csv where the custom Field (Multi_line) has around 20K characters.

Although this may be related to the Microsoft Excel having a character limit of 32,767 characters in a cell, it will be useful to have a feature to restrict the max characters that can be exported from a field while exporting issues in CSV/Excel format to avoid this.