Description: ------------ $textFormat->setNumFormat('@') or $textFormat->setNumFormat(49) doesn't work for formatting data as text (such as numbers that you want stored as text). I referred to open office document for the excel file format (page 160) for the @ and the 49 that should refer to formatting as text. So numbers starting with zero loose their zeros and long numbers show as scientific notation. Test script: --------------- <?php require_once "Spreadsheet/Excel/Writer.php"; $workbook =& new Spreadsheet_Excel_Writer(); $workbook->send('test.xls'); $textFormat =& $workbook->addFormat(); $textFormat->setNumFormat('@'); //or 49 $sheet1 =& $workbook->addWorksheet('Not my first sheet'); $sheet1->setColumn(0,0,20,$textFormat); $sheet1->write(0,0,"000034534"); $sheet1->write(1,0,"100000298109"); $sheet1->write(2,0,"00324838284"); $sheet1->write(3,0,"00456744675454654556"); $workbook->close(); ?> Expected result: ---------------- 000034534 100000298109 00324838284 00456744675454654556 Actual result: -------------- 34534 1E+11 324838284 4.56745E+17

Bugs 3514 and 8323 are perhaps related to this, but the test case here most accurately reflects the problem I want to solve. I did so by patching the write() function in Worksheet.php; the first if statement looks for a number, although it should only do so when (!$format || $format->_num_format))

I try to cope with the same problem here. I can't export german postal codes and area codes for telephones. For me this has the highest priority of all bugs. By the way, is this project still active?

I can verify this problem.

This package does seem to be abandoned. I've personally moved my projects over to PHPexcel which is very active and very mature, supporting much of the newer formats. http://www.codeplex.com/PHPExcel/

Reconbot - we released a new version of this package today. Please don't spam the bugtracker with non-helping comments.

Thank you for your bug report. This issue has been fixed in the latest released version of the package, which you can download at http://pear.php.net/get/