Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.2
Bug #9516 Writer produces damaged XLS file
Submitted: 2006-12-01 03:58 UTC Modified: 2009-11-14 07:41 UTC
From: joeri_sebrechts at hotmail dot com Assigned: progi1984
Status: Closed Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 4.4.2 OS: Windows XP Pro
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: joeri_sebrechts at hotmail dot com
New email:
PHP Version: Package Version: OS:

 

 [2006-12-01 03:58 UTC] joeri_sebrechts at hotmail dot com (Joeri Sebrechts)
Description: ------------ When writing an XLS file using the code from the testxls.php file contained in the associated zip file, a damaged XLS file is produced. When trying to open this file in excel 2003 (build 11.5612.6360) it shows the following error: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. My php.ini file is included in the zip file as well. Test script: --------------- http://www.sharebigfile.com/file/29147/excelwriterproblem.zip.html Expected result: ---------------- An undamaged XLS file containing the data from the JSON object in the testxls.php script. Actual result: -------------- A damaged XLS file.

Comments

 [2006-12-05 01:53 UTC] tuupola at php dot net (Mika Tuupola)
What is contents of 'library/lib.pear.php'?
 [2006-12-05 02:54 UTC] joeri_sebrechts at hotmail dot com
It's a library that uses ini_set to modify the include_path so that it can find the pear libraries. If pear is in your include_path by default that line shouldn't be necessary.
 [2006-12-20 11:11 UTC] joeri_sebrechts at hotmail dot com
I have since troubleshooted this issue further. It seems to be caused by using the BIFF8 format. When I remove the setVersion(8) line things work fine (except that there is no UTF-8 support). I suspect this is related to bug 2010.
 [2008-03-22 09:48 UTC] doconnor (Daniel O'Connor)
The test script now 404s. Any chance of a new script?
 [2008-03-25 03:04 UTC] joeri_sebrechts at hotmail dot com
http://sebrechts.net/files/2008/excelwriterproblem.zip As an aside, I got it working in UTF-8 mode, with version 8. See bug 2010.
 [2009-08-05 15:29 UTC] progi1984 (Franck Lefevre)
So this bug can be closed ?
 [2009-11-14 02:08 UTC] iterator (Nonya Business)
Too many calls to Worksheet::setMerge() on one worksheet caused a damaged xls file. Eventually after hours of debugging I found the problem. I was merging pairs of vertical cells.
 [2009-11-14 07:41 UTC] progi1984 (Franck Lefevre)
-Status: Open +Status: Closed -Assigned To: +Assigned To: progi1984