Pear Spreadsheet_Excel_Writer vs. PHP 5.3

Pear Spreadsheet_Excel_Writer created on PHP 4.

Trials to solve problem:

https://github.com/pear/Spreadsheet_Excel_Writer

other software:

http://www.fusonic.net/en/blog/2012/03/08/simplified-php-spreadsheet-excel-export/

http://phpexcel.codeplex.com/

deprecated error report & solution:

http://pear.php.net/bugs/bug.php?id=16678&edit=3

http://grokbase.com/t/php/pear-bugs/09a5rhcz3b/pear-bug-bug-16678-opn-in-php-5-3-get-errors-on-lines-186-195

error when deal with a large amount of data

http://stackoverflow.com/questions/2674489/spreadsheet-excel-writer-data-output-is-damaged

The solution is change in Root.php line 623 :

fwrite($FILE, pack("V", 1));

to

fwrite($FILE, pack("V", $num_sb_blocks));

the file is pear/OLE/PPS/Root.php in package OLE 1.0.0RC2 (beta)

http://pear.php.net/bugs/bug.php?id=19284&edit=3