AW: POI line feed/Carriage Return Problem

[karl-heinz (SAW)]

Hi Ian.   During your processing it’s stored in a string. And strings contain the replace() method.   MfG Karl-Heinz Zengerle ___________________________________________________  More than competence in Document Management ___________________________________________________ SAW AG Waldm�nchenerstr. 12 81549 M�nchen Tel.: ++49-89-68088368 Fax: ++49-89-68088389 www.sawag.com ___________________________________________________ -----Urspr�ngliche Nachricht----- Von: iansdev [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. Dezember 2003 07:23 An: [EMAIL PROTECTED] Betreff: Re: POI line feed/Carriage Return Problem   Thanks , Danny it seems that ur right..do you know how can I replace the \r with \n..   again thanks.. ian   -------Original Message-------   From: POI Users List Date: Tuesday, December 09, 2003 08:39:28 To: POI Users List 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-------/ > > /*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/HSSFCell > 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]   . ____________________________________________________   IncrediMail - Email has finally evolved - Click Here