Bug 46712

Summary: Turkish character support
Product: POI Reporter: Tufan <tufang>
Component: XSSFAssignee: POI Developers List <dev>
Status: CLOSED LATER    
Severity: enhancement    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Attachments: csv file

Description Tufan 2009-02-13 05:33:46 UTC
When I try to write Turkish ( 'ş', 'ğ', 'İ', 'Ş', 'Ğ' ) characters into a new Excel file, I am having display errors. However,when it comes to write other characters like ('i', 'ü', 'ç') it displays properly in the generated Excel file.
I attached the sample generated Excel file. It would be useful to add Turkish character support to POI.

I apply the lines below when inserting new values into all of the cells in the Excel sheet :

HSSFCell cell0 = row.getCell((short) 0);
cell0.setCellStyle(cellStyle);
cell0.setCellType(HSSFCell.CELL_TYPE_STRING);
cell0.setEncoding(HSSFCell.ENCODING_UTF_16);

I am using poi 2.5.1 version.

Thanks in advance.
Comment 1 Tufan 2009-02-13 05:34:45 UTC
Created attachment 23255 [details]
csv file
Comment 2 Nick Burch 2009-02-13 05:39:53 UTC
poi 2.5.1 is over 4 years old...

Try with a recent POI version. If you have your java correctly setup for unicode (most people do), you'll then be fine to put unicode in richtextstrings and have them displayed
Comment 3 Tufan 2009-02-13 06:15:32 UTC
Hi;

I have just updated the version of POI used to 3.1 and it started to work correctly. Thanks for your help and consideration.

Regards;