DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322

can't read ÜÖÄüöä ... sometimes.





------- Additional Comments From [EMAIL PROTECTED]  2002-08-20 11:40 -------
Thanks, that's all I wanted to know.

The source is very simple:

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
wb.setSheetName( sheetcounter, sheetName );
HSSFRow row = sheet.createRow((short)rowcounter);
HSSFCell cell = row.createCell((short)0);       
cell.setEncoding( HSSFCell.ENCODING_UTF_16 );
cell.setCellType( HSSFCell.CELL_TYPE_STRING );
cell.setCellValue(iETI.getLanguage());
/*multiple cells...*/
byte[] bytes = wb.getBytes();
POIFSFileSystem fs = new POIFSFileSystem();
fs.createDocument(new ByteArrayInputStream(bytes), "Workbook");
ByteArrayOutputStream byteos = new ByteArrayOutputStream();
fs.writeFilesystem(byteos);
byteos.close();
return byteos;

The thing is, which I've explained, the error occurs when you write out the 
file, manually change it, and read the file again with HSSF. Then the above 
mentioned errors occur. HSSF has propblems recognizing if the cells are saved 
as 8 or 16 bit, depending on if the characters in the cell are between ascii: 0-
128 or 129-159 or 160-255.

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to