Home » File Formats » Spreadsheet_Excel_Writer » Bug #944

[2004-03-04 06:52 UTC] jan dot luebke at gmx dot de

Description:
------------
When directly opening the Excel-File with Microsoft Internet Explorer (6.0), the repeatRows()-Function doesn't work.

If you choose to save the file do disk and then open it, the repeatRows get repeatet.

BUT: If you use Mozilla (1.6), it doesn't matter if you choose to open or save it (I use the Download-Manager).

I don't have a clue how this happens, but it seems like a client-side problem.

If you want to test it yourself, just run the following code:

Reproduce code:
---------------
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet('Sheet1');
$workbook->send('test.xls');

$worksheet->write(0, 0, 'first Row (should appear on every page');
$worksheet->repeatRows(0,0); // <- Doesn't work
// Fill some pages
for ($i=3; $i < 100; $i=$i+3) {
$worksheet->write($i, 0, 'somedumbtext');
}

$workbook->close();
?>

Expected result:
----------------
The row should get repeated no matter if I choose to open or save the file.

Actual result:
--------------
The row doesn't get repeatet if I choose to open.

Hope this description helps. I haven't checked, but this bug might be related to the bug #581 (RepeatColumns).

[2004-06-04 14:17 UTC] scottfishr at aol dot com

For what we us this program for this is the only bug that really needs to be fixed. Has anyone come up with any sort of work around for this?

I am using IE6 and get the same exact results as the original submission.

[2004-06-23 14:29 UTC] jan at traum-projekt dot com

Microsoft Excel XP has a problem with files named filename[1].xls - every file that is direktly opended by IE out of its cache is renamed in this style and get excel mixed up.

So... it seems to be an excel-problem not Spreadsheet_Excel_Writer. Try it by renaming a local file to bla[1].xls and open it...

btw: the behavior has some more effects:
- You can't set panes with Spreadsheet_Excel_Writer
- you can't rename the worksheet
...and so on

I hope that helps!

Jan

[2004-09-30 20:31 UTC] casep at tuxpan dot com

Ok, but if you directly from Excel create a file with name dummy[1].xls it does not happens. Or even if you create a file dummy.xls and then rename it to dummy[1].xls.
But, if you save the PEAR generated file as report.xls it's ok, but after remame it to report[1].xls there is no repeated rows :-(

[2004-11-09 13:58 UTC] todoit at rambler dot ru

I have the same problem, but i don't use this function. Just if open file directli form IE - my xls dosnt work. If i save file (never mind which name i call it) it's opened ok. There is a problem and how fix it?

[2004-11-29 14:54 UTC] linux at mbaierl dot com

Any update until now? This bug is open since March...

[2005-03-03 19:30 UTC] spowers at gotoami dot com

I cant seem to get this to work at all. I've tried firefox 1.0 and IE 6.0.

None of the work arounds posted here seem to work for me, and even if they did arent practical for my application.

This bug (and the repeat cols bug) should def be top priority.

[2005-04-26 13:42 UTC] wongmanii at hotmail dot com

Hi,

Is there really no way to use this Spreadsheet_Excel_Writer with an already existing file???

Couldn't we change something in the source code to make that feasible? It does not seem so difficult...

What do you think?

[2006-03-20 17:08 UTC] chris at nospam dot crystalfusion dot com

I find the same issue with Internet Explorer 7 Beta 1. This is a big issue since it is one of the reasons I used Excel instead of trying to format HTML or a PDF.

[2006-06-08 18:10 UTC] somekindofemail at anemailaddress dot com

I've got the same problem (repeatRows doesn't work) when
sending the spreadsheet as an attachment in an email. When I
receive and open the email from entourage, the rows do not
repeat, but when I receive and open the same email with mail
(mac), the rows do repeat. What is up with this?

[2007-01-16 16:20 UTC] alessandro at acqualba dot it

I can confirm this behaviour

direct excel opening from MSIE 6 : no repeat
download + save to disk + open : repeat ok

BTW it seems an excel-related problem.

I will test the effect of sending different headers, will report positive results here (if any).