[PEAR-BUG] 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