RE: [PEAR] Excel Spreadsheet Writer Line Breaks
| From: | Hundiak, Arthur | Date: | Fri, 01 Aug 2003 16:35:07 +0000 |
| Subject: | RE: [PEAR] Excel Spreadsheet Writer Line Breaks | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-6946@lists.php.net to get a copy of this message | ||
Never mind. I figured it out right after sending the email.
$format1->setTextWrap();
-----Original Message-----
From: Hundiak, Arthur
Sent: Friday, August 01, 2003 10:32 AM
To: 'pear-general@lists.php.net'
Subject: [PEAR] Excel Spreadsheet Writer Line Breaks
I am trying to add multiples lines to one spreadsheet cell.
Same thing as using ALT-ENTER when entering data in a spreadsheet.
$worksheet->write(0,0,"Line 1\nLine 2");
The above does not work under an all Windows enviroment (Windows 2K, Apache,
Excel 2K). I get a little rectangular box in the cell between "Line 1" and
"Line 2". It actually works using OpenOffice Scalc.
Any help would be appreciated.
--
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php