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

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;