You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by David Thielen <da...@windward.net> on 2004/12/08 21:58:06 UTC

RE: Asking again: unicode not working


-----Original Message-----
From: David Thielen [mailto:david@windward.net] 
Sent: Wednesday, December 08, 2004 11:02 AM
To: 'POI Users List'
Subject: Asking again: unicode not working

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



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


RE: Asking again: unicode not working

Posted by David Thielen <da...@windward.net>.
That was it - thank you!

-----Original Message-----
From: Avik Sengupta [mailto:avik.sengupta@itellix.com] 
Sent: Wednesday, December 15, 2004 5:56 AM
To: POI Developers List
Cc: David Thielen
Subject: RE: Asking again: unicode not working

You should probably try

cellOn.setEncoding(HSSFCell.ENCODING_UTF_16 );

compressed unicode, AFAIK is an MS term that does not mean what it
says :(

On Wed, 2004-12-08 at 13:58 -0700, David Thielen wrote:
> 
> -----Original Message-----
> From: David Thielen [mailto:david@windward.net] 
> Sent: Wednesday, December 08, 2004 11:02 AM
> To: 'POI Users List'
> Subject: Asking again: unicode not working
> 
> 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
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
> 
-- 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


RE: Asking again: unicode not working

Posted by Avik Sengupta <av...@itellix.com>.
You should probably try

cellOn.setEncoding(HSSFCell.ENCODING_UTF_16 );

compressed unicode, AFAIK is an MS term that does not mean what it
says :(

On Wed, 2004-12-08 at 13:58 -0700, David Thielen wrote:
> 
> -----Original Message-----
> From: David Thielen [mailto:david@windward.net] 
> Sent: Wednesday, December 08, 2004 11:02 AM
> To: 'POI Users List'
> Subject: Asking again: unicode not working
> 
> 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
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
> 
-- 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org