1.14 Localization Issues

1.14.1 Chinese Characters in Activity Logs

When a report.csv file for an activity report is opened in Microsoft Excel, Chinese characters do not display correctly, even though the report.csv file has been created correctly. This is because Excel always reads the file using the ISO Latin character set.

One workaround is to use the OpenOffice.org Calc spreadsheet program instead of Excel. It displays Chinese characters correctly.

As a workaround in Excel:

  1. Import the report.csv file into Excel by using Data > Import External Data > Import Data.

  2. Select the report.csv file, then click Open.

  3. Select Delimited, select UTF-8, then click Next.

  4. Select Comma as the delimiter, click Next, then click Finish.

Excel should now display the Chinese characters correctly.