|
Thanks , Danny it seems that ur right..do you know how can I replace the \r with \n..
again thanks..
ian
-------Original Message-------
Date: Tuesday, December 09, 2003 08:39:28
Subject: Re: POI line feed/Carriage Return Problem
Can you examine the characters in the string? i have a suspicion there
is an \r in there (or some additional character) somewhere. I pass in
\n and things wrap nicely.
iansdev wrote:
> Thanks, Shawn but it wrap but the square box is still there..
> any more suggestion...
>
> thanks,
> ian
>
> /-------Original Message-------/
>
> /*Date:*/ Tuesday, December 09, 2003 00:11:09
> /*Subject:*/ RE: POI line feed/Carriage Return Problem
>
> Nothing about the other replies you may have gotten but they are way off the
> mark. You need to set the cell style for the cell with option of text to be
> wrapped.
>
> Here is an example from code that I wrote about a year ago that had the same
> problem:
>
> HssfCellStyle wrap = book.createCellStyle();
>
> wrap.setFont(font);
>
> wrap.setWrapText(true);
>
>
>
> and then when I put the text in the cell,
>
> cell.setCellValue(remark);
>
> cell.setCellStyle(wrap);
>
>
>
> What is happening is that it does not know that it needs to wrap the text if
> so it doesn't know what the carriage return character should look like.
>
> Shawn
>
>
>
> Style.html#setWrapText(boolean)
>
>
>
> _____
>
> Sent: Monday, December 08, 2003 3:42 AM
> Subject: POI line feed/Carriage Return Problem
>
>
>
>
> Hi!
>
> I can anyone help with these..
>
>
>
> Using POI. i have a problem writing a data on excel with line feed/Carriage
> Return (data is from a Oracle datable) it seems that it doen't recognized
> the line feed/Carriage Return (it replaces with square thing)..
>
>
>
> Can anyone help me..
>
>
>
>
>
> Thanks in Advance,
>
>
>
> Caezar Ian Santilla
>
> Web Developer
>
> 6/F Alpap I Bldg., 140 L.P. Leviste St.
>
> Salcedo Village, Makati City
>
> Manila, Philippines
>
> Tel: +63 (0) 2 751 7010 - ext 112
>
> Fax: +63 (0) 2 751 7013
>
>
>
>
>
>
>
>
>
>
> ____________________________________________________
> Email has finally evolved -
>
>
>
>
>
> ____________________________________________________
> *Email has finally evolved* - *_Click Here_*
---------------------------------------------------------------------
. | 