Hi Danny. I also had this problem now and remembered the solution. In my case there is a "\n" so nothing is replaced and the squares are printed. Do you have a further idea.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Danny Mui [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. Dezember 2003 01:40 An: POI Users List Betreff: 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-------/ > > /*From:*/ POI Users List <mailto:[EMAIL PROTECTED]> > /*Date:*/ Tuesday, December 09, 2003 00:11:09 > /*To:*/ POI Users List <mailto:[EMAIL PROTECTED]> > /*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 > > > > http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSF Cell > Style.html#setWrapText(boolean) > > > > _____ > > From: iansdev [mailto:[EMAIL PROTECTED] > Sent: Monday, December 08, 2003 3:42 AM > To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> > > > > > > > > > > ____________________________________________________ > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9 > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9>> IncrediMail - > Email has finally evolved - > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9 > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9>> Click Here > > > > > > ____________________________________________________ > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> /IncrediMail/ - > *Email has finally evolved* - *_Click Here_* > <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
