Re: Spreadsheet Writer cell sizes

Justin Patrin wrote:

On 12 Nov 2004 07:00:23 -0000, PHPDiscuss - PHP Newsgroups and mailing lists <lliddell@cs.up.ac.za> wrote:

Hi everyone 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? 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 *think* that using the "new experimental" format will do this, but you'll have to hunt for the ay to do it (look at the source).

We're getting around the 255 char limit with these calls: $workbook->_codepage = '1251'; $workbook->setVersion(8); So far, no problems... James Marrs