Asking again: unicode not working

[David Thielen]

Hi;

 

I create my spreadsheet using:

    wb = new HSSFWorkbook();

    sheet = wb.createSheet();

    wb.setSheetName(0, process.getTitle(), HSSFWorkbook.ENCODING_UTF_16);

 

For each cell I do:

    cellOn = rowOn.createCell(cellOnInd);

    cellOn.setEncoding( HSSFCell.ENCODING_COMPRESSED_UNICODE );

 

But when I do a:

    // code not shown â set font to Arial Unicode MS

    cellOn.setCellValue(âââÐÐâ); // if you use a text mail client 
this is Euro, TM, and 2 russian characters

 

I get:

    Â" // if you use a text mail client, then is 3 PC graphics chars and a â

 

And the cell is set to use Arial Unicode MS.

 

Any ideas?

 

Thanks - dave