Products | Versions |
---|---|
Spotfire Statistica | 13.2 |
PROBLEM RECAP (13.2 installed):
1. Go to Control Panel | Regions, and change System Locale to Japanese
2. Open a Statistica spreadsheet with Japanese characters in Statistica 13.2. Note that Japanese characters are successfully displayed in Statistica.
3. In Statistica, go to "File | Save as" to save the spreadsheet to .csv file
4. Open the saved .csv file in Notepad, Japanese successfully displayed.
5. Select the saved .csv file, right click mouse to display the dropdown menu, choose "Open with" and select "Microsoft Excel" to open the .csv file in Excel. Observe that Japanese characters are failed to be displayed.
This issue is due to the reason that Statistica 13.2 saves CSV file with UTF-8 encoding, and Excel reads CSV file by default with ANSI (Shift jis) encoding.
To make Excel to read CSV file saved from Statistica with UTF-8 encoding and correctly display Japanese characters,
1. Open an empty Excel template, go to "Data | From Text", browse to the .csv file saved from Statistica 13.2. Click on "Import".
2. Follow the Excel "Import Text" wizard.
Click Next to finish importing CSV file to Excel
4. By using the "Import Text" wizard, Excel is able to read the Japanese Characters in the UTF-8 encoded CSV file.