Home » File Formats » Spreadsheet_Excel_Writer » Bug #8601

[2006-08-31 19:45 UTC] wizard at roborooter dot com

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