Re: Spreadsheet Writer cell sizes

----- Original Message ----- From: "PHPDiscuss - PHP Newsgroups and mailing lists" <lliddell@cs.up.ac.za> To: <pear-general@lists.php.net> Sent: Friday, November 12, 2004 9:00 AM Subject: [PEAR] Spreadsheet Writer cell sizes Hello! Louise wrote: > > I have been using the PEAR Spreadsheet writer to dynamically generate an > Excel spreadsheet for download. I have 2 problems: > > 1. The data I insert into the cells consists of a string of data > containing a number of '\n' characters. I have set the cell sizes, but > they do not expand to that size automatically. Rather, they stay at the > size of a normal 1-lined cell and I have to click on the data in the cell > to have it to expand the cell to fit the data. How can I fix this? Did you try setRow($xl_row,$height,$format), where $height=/*for instance*/strlen($text)/20/*e.g. 30,40,50 - so many as it fits in one cell's row -- find this number by trying different values*/; and $xl_row -- the row generated now? > > 2. Some of the data I want to write to a cell is longer than 255 > characters. Is there a way getting around the 255 character limit? I know no way. > > Any help would be appreciated :) > > Louise > You're welcome, Valeriy Krizhevich