I am working in a web application, where users can export the products as xls file. This functionality is done with pear excel writer in PHP. It is working fine.
All of a sudden we got some special characters(looks like chinese or korean) in the cells.
I started debugging the problem. I've searched for special characters in product names but names are fine. Then I've commented a function calling line, it started working. The function name is setVersion, which I have not used anywhere below is the comments from the pear site.
-----------------
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setversion.php This method exists just to access experimental functionality from BIFF8. It will be deprecated ! Only possible value is 8 (Excel 97/2000). For any other value it fails silently.
-----------------
All of a sudden we got some special characters(looks like chinese or korean) in the cells.
I started debugging the problem. I've searched for special characters in product names but names are fine. Then I've commented a function calling line, it started working. The function name is setVersion, which I have not used anywhere below is the comments from the pear site.
-----------------
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setversion.php This method exists just to access experimental functionality from BIFF8. It will be deprecated ! Only possible value is 8 (Excel 97/2000). For any other value it fails silently.
-----------------
