Description: ------------ I am trying to make a certain cell of the excel spreadsheet as Text so I could display a number with a leading zero. e.g. 07432 instead of 7432 Reproduce code: --------------- $text_format =& $workbook->addFormat(); $text_format->setNumFormat('@'); $worksheet->write($i,14,"' ".$colO,$text_format); Expected result: ---------------- expected result 07432 Actual result: -------------- produces result as '07432

doesnt look like a doc bug to me

similar problem, maybe the same Bug: Description: Two fields, formatted as time-value, contains a time value, but with leading ', so another field, declared as a formula-field can't get the correct SUM of the other two fields. code: $format_time =& $workbook->addFormat(); $format_time->setNumFormat("hh:mm:ss"); $worksheet->write($i,3,"12:00:00",$format_time); expected result: ---------------- 12:00:00 produced result: ----------------- '12:00:00

To cater for leading zero value, add the following to the function write in Worksheet.php function write($row, $col, $token, $format = 0) { // leading zero or string format if ($format->_num_format=='@' || preg_match("/^0/", $token)) return $this->writeString($row,$col,$token,$format); ......... }

christianm, did you try using writeNumber() ? write() actually calls other methods depending on the type of the third argument given, and you are giving it a string ("12:00:00").

ankush, if you want to use a numeric value as text in a cell, use writeString(). Is that what you want?