Bug #17322 [Com]: setVersion(8) + repeatRows(x,x) caused invalid sheet

Edit report at http://pear.php.net/bugs/bug.php?id=17322&edit=1 ID: 17322 Comment by: bkline Reported By: bkline at rksystems dot com Summary: setVersion(8) + repeatRows(x,x) caused invalid sheet Status: Feedback Type: Bug Package: Spreadsheet_Excel_Writer Operating System: Linux Package Version: Unknown PHP Version: 5.2.5 New Comment: The problem still exists with PHP 5.6.31 and the latest version of the package (0.9.4). Here's a repro case: <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); $worksheet =& $workbook->addWorkSheet(); $worksheet->setColumn(0,0,100); $worksheet->write(0,0,"99 Bottles Of Beer On The Wall- The Complete Lyrics"); $worksheet->repeatRows(0); for ($i = 99; $i > 0; $i--) { $next = $i > 1 ? $i - 1 : "no more"; $verse = "$i bottles of beer on the wall, $i bottles of beer; take one " . "down, pass it around, $next bottles of beer on the wall."; $worksheet->write(100 - $i, 0, $verse); } $workbook->send('repro.xls'); $workbook->close(); ?> Previous Comments: ------------------------------------------------------------------------ [2017-05-24 22:25:14] sanmai <div id="changeset"> <span class="removed">-Status: Open</span> <span class="added">+Status: Feedback</span> </div>Thank you for taking the time to report a problem with the package. Unfortunately you are not using a current version of the package -- the problem might already be fixed. Please download a new version from http://pear.php.net/packages.php If you are able to reproduce the bug with one of the latest versions, please change the package version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PEAR. ------------------------------------------------------------------------ [2010-04-19 19:47:19] ron8000 Description: ------------ When you use the $workbook->setVersion(8) AND you use the $worksheet->repeatRows(x,x) the sheet that is generated will be invalid and cause excel to report an error. ------------------------------------------------------------------------ -- Edit this bug report at http://pear.php.net/bugs/bug.php?id=17322&edit=1