-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
7.3.0, 8.2.4, 8.5.1, 8.13.4, 8.18.0
-
7.03
-
66
-
Severity 3 - Minor
-
29
-
Problem
When viewing the exported CSV file in Excel, the non-english characters aren't rendered correctly.
Steps to Replicate
- Create an issue with special characters
- Go to Issue Navigator and click Export > Current fields
- Open the exported CSV in Excel
Expected Behaviour
The special characters are displayed properly.
Actual Behaviour
Special characters are not correctly rendered. As an example, "phố xưa" is displayed as "phố xÆ°a" when viewed in Excel.
Workaround
Open the exported CSV file with Notepad++. Under "Encoding", it should be shown File is UTF-8 without BOM. Converting the file to UTF-8 with BOM will allow the file to be displayed correctly in Excel.
Related KB: Exported CSV does not display properly in Excel that contains non-English characters
Note
Viewing the CSV in text editor works fine.
- duplicates
-
JRASERVER-63857 Can't open exported CSV in Microsoft Excel
- Closed
- is related to
-
JRASERVER-67469 Inconsistency date Export using Date Custom Field with different Language Configured
- Gathering Impact
- was cloned as
-
JRACLOUD-77924 Special Characters Exported via CSV not Rendered Correctly in Excel
- Closed
- mentioned in
-
Page Loading...
- relates to
-
SSE-776 Loading...