Bug #7315 [Com]: Freeze Panes - error with only 2 values

Edit report at http://pear.php.net/bugs/bug.php?id=7315&edit=1 ID: 7315 Comment by: wardjk Reported By: wardjk at comcast dot net Summary: Freeze Panes - error with only 2 values Status: Feedback Type: Bug Package: Spreadsheet_Excel_Writer Operating System: Windows XP PHP Version: 5.1.2 Assigned To: progi1984 New Comment: This bug still exists in version 0.9.4. All 4 values must still be provided. Previous Comments: ------------------------------------------------------------------------ [2012-01-26 04:31:10] doconnor Is Bug #17083 a dupe? ------------------------------------------------------------------------ [2011-01-10 21:49:15] ecaron I believe this errors comes from having PHP Notices turned on in the _storePanes function. I've attached a patch that checkes if the 3rd and 4th value of $panes is set, and then properly checks rwTop and colLeft later on (so it knows when to use the default values). ------------------------------------------------------------------------ [2011-01-10 21:47:20] ecaron Added #patch bug:7315;patch:freezepane-2-value-check;revision:1294696040;. ------------------------------------------------------------------------ [2009-08-12 09:01:04] progi1984 <div id="changeset"> <span class="removed">-Status: Open</span> <span class="added">+Status: Feedback</span> <span class="removed">-Assigned To:</span> <span class="added">+Assigned To: progi1984</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. Could you test with the latest version of the package ? require_once 'Spreadsheet/Excel/Writer.php'; $WB =& new Spreadsheet_Excel_Writer(); $sheet1 =& $WB->addWorksheet('Feuille1'); $sheet1->freezePanes(array(6, 0)); $WB->send('test'.date('His').'.xls'); $WB->Close(); Thanks you for advance ------------------------------------------------------------------------ [2006-04-05 09:31:01] taggartm at gmail dot com Description: ------------ The documentation states that this should work to freeze the first 6 rows of a worksheets. $worksheet->freezePanes(array(6, 0)); This actually generates an error saying it can't find reference 2 and 3. If you specify all the values then it works just fine. $worksheet->freezePanes(array(6, 0, 0, 0)); Either the code needs to be changed to test how many values are present in the array or the documentation needs to be changed to say it needs all the values. ------------------------------------------------------------------------ -- Edit this bug report at http://pear.php.net/bugs/bug.php?id=7315&edit=1