Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.2

Bug #9640 Date problem with big spreadsheet
Submitted: 2006-12-16 15:12 UTC Modified: 2009-11-29 01:50 UTC
From: piotr at 1h dot pl Assigned: cschmitz
Status: Closed Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 4.3.11 OS: Linux
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: piotr at 1h dot pl
New email:
PHP Version: Package Version: OS:

 

 [2006-12-16 15:12 UTC] piotr at 1h dot pl (Peter)
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.

Comments

 [2006-12-16 16:00 UTC] piotr at 1h dot pl
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.
 [2006-12-16 16:13 UTC] piotr at 1h dot pl
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() ) ) ); }
 [2009-11-29 01:50 UTC] cschmitz (Carsten Schmitz)
-Status: Open +Status: Assigned -Assigned To: +Assigned To: cschmitz
 [2009-11-29 01:50 UTC] cschmitz (Carsten Schmitz)
-Status: Assigned +Status: Closed
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/