From:  bkline@rksystems.com ("bkline")
Date:  28 Oct 2017 20:50:40 Hong Kong Time
Newsgroup:  news.php.net/php.pear.bugs
Subject:  

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

NNTP-Posting-Host:  null

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:

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

-Status: Open +Status: Feedback
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