Description: ------------ I want to format a particular column as text, as opposed to general. I tried the following, where 9 should correspond to the text cell format, but I guess there's a problem in the module itself, as it is still formatted as general. Re. bug #3514: this appears related but distinct in that my understanding is that setNumFormat should take an integer corresponding to a particular cell format. Test script: --------------- $date_format =& $workbook->addFormat(); $date_format->setNumFormat(9); $worksheet->setColumn(3,3,12,$date_format); Expected result: ---------------- The third column should be formatted as type text (9). Actual result: -------------- The third column is formatted as type general (0).

the string for text "@" also doesn't work, oddly enough the number I found for text is 49, it doesn't work either. http://sc.openoffice.org/excelfileformat.pdf page 160 (section 6.45)

Thank you for taking the time to write to us, but this is not a bug. It's an error of use. Use this code and the column will be at the format TEXT. <?php require_once 'Spreadsheet/Excel/Writer.php'; $xls = new Spreadsheet_Excel_Writer(); $worksheet = $xls->addWorksheet("test"); $date_format =& $xls->addFormat(); $date_format->setNumFormat('@'); $worksheet->setColumn(3,3,12,$date_format); $xls->send('test'.date('His').'.xls'); $xls->close(); ?>