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).

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.

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

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 :-(

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?

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

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.

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?

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.

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?

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).

Does anyone have a better solution for this problem? I can confirm the behavior of the original poster - running in IE7 and Excel 2003 SP2.

I have the same problem with IE 7. Any solutions since 1 year? Please help.

Or are there any replace functions for this ? ...

The function is working when i remove $xls->setVersion(8); when it is not removed it doesn't work...

I just made a hexadecimal diff between two excel files (one opened from IE (with the problem) and the another one saved from IE (with no problem)). And there is a difference :this is the date for the generation which is saved in file.

Others tests : The first file is : test150731.xls (file saved, so no problem) The Second file is test150735[1].xls (file opened, so problem) I open the second file and i haven't the repetition of first line. I close it. I rename it to test150735.xls. I open it. I have the repetition of first line. I close it. I rename it to test150735[1].xls. I open it. I haven't the repetition of first line. So the bug come from Excel. After some searchs in internet, my answer is right. http://support.microsoft.com/kb/306656/en-us http://php.kennedydatasolutions.com/blog/2008/02/05/internet-explorer-breaks-excel-pivot-tables/ And the answer is : Internet Explorer adds ‘[X]’ to the end of the file name when storing the file in the IE temp folder, where X represents an incrementing integer based on the number of downloads of the same file, and the square brackets are illegal characters for file names in Windows. SO the problem is not SpreadSheet_Excel_Writer but the Excel software.

Sorry, but your problem does not imply a bug in PEAR itself. For a list of more appropriate places to ask for help using PEAR, please visit http://pear.php.net/support/ as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PEAR. As said in my last comment, it's an Excel bug.