Description: ------------ I've got the problem with dates and strings in long spreadsheet generated from SQL database. After 300. row spreedsheet messes up in some rows. Some bugs apears in string and date fields. Test script: --------------- while ( $d = $db->nextrow() ){ $sheet -> writeString( $row,0,$d['dat_01'],$format1 ); $sheet -> writeString( $row,1,$d['dat_02'],$format2 ); $row ++; } Expected result: ---------------- 298:2005-10-10 2006-12-05 299:2006-10-23 2006-12-11 300:2006-11-08 2006-11-07 301:2005-05-20 2006-11-28 302:2005-06-10 2006-11-10 Actual result: -------------- 298:2005-10-10 2006-12-05 299:2006-10-23 2006-12-11 300:2006-11-08 2006-11-07 301:2005-05-20 2006-11-28 302:2005-06-10 2006-1?1?- similar results witch ASCI text.

A bug apears when $sheet -> setInputEncoding('utf-8') is set and the spreadsheet is viewed in OpenOffice.org 2.0. I'll try to look at MS Excel and see if it steel apears.

MS Excel doesn't open spreadsheet at all. I've noticed, that any setting any input encoding causes bugs in spreadsheet - the most simple example: $sheet = &$xls->addWorkSheet('test'); $sheet -> setInputEncoding('ISO-8859-2'); for ($i = 0; $i<1000; $i++){ $sheet -> write($i,0,date('Y-m-d',rand( 0,time() ) ) ); $sheet -> write($i,1,date('Y-m-d',rand( 0,time() ) ) ); }

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/