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)