You should replace every linefeed or carriage return once you retrieve the record before populating it to excel. happy hacking!!
 
 
Thank you.
 
Random Law of Programming: There are two ways to write error-free
programs. Only the third one works.
 
Norman B. Ordas
Software Developer II
Engineering Department (MIS)
Qinteraction Phils., Inc.
8/F BPI-Buendia Center,
Sen. Gil Puyat Ave.
Makati City, Philippines 1200
TEL #: (63) 02-8781500 loc 3507
MOBILE: (0927) 4426674
E-MAIL: [EMAIL PROTECTED]
WEB: http://www.qinteraction.com
----- Original Message -----
From: iansdev
Sent: Monday, December 08, 2003 6:02 PM
Subject: Re: AW: POI line feed/Carriage Return Problem

Hi! Karl.. thanks for the fast answer,
 
on the debugger when i Outprint it its Ok.. the next character goes down... the excel itself display a  square thing... do you know how can i solve these....
 
To do these on excel Manually... you will Press the ALT+Enter key to create a linefeed/Carriage Return  on the same cell.
 
ian
 
-------Original Message-------
 
Date: Monday, December 08, 2003 17:53:38
Subject: AW: POI line feed/Carriage Return Problem
 

Hi Ian.

 

Often the squares are just a kind of displaying nonprintable characters. Did you look in the debugger or in Excel itself?

 

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: Montag, 8. Dezember 2003 10:42
An: [EMAIL PROTECTED]
Betreff: 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]

 

 

 

  IncrediMail - Email has finally evolved - Click Here

 
____________________________________________________
  IncrediMail - Email has finally evolved - Click Here
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to