Bug 46712 - Turkish character support
Summary: Turkish character support
Status: CLOSED LATER
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-13 05:33 UTC by Tufan
Modified: 2009-02-13 06:15 UTC (History)
0 users


Attachments
csv file (5.00 KB, text/csv)
2009-02-13 05:34 UTC, Tufan 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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;