|
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 -
| 