| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #9516 | Writer produces damaged XLS file | ||
|---|---|---|---|
| Submitted: | 2006-12-01 08:58 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) | ||
[2006-12-01 08: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 06:53 UTC] tuupola at php dot net
(Mika Tuupola)
What is contents of 'library/lib.pear.php'?
[2006-12-05 07: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 16: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 13:48 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-03-25 07: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 20:29 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2009-11-14 07:08 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2009-11-14 12:41 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!