Send a blank email to [email protected] to get a copy of this message
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