| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #4174 | MS Outlook 2003 corrupts excel files generated by version .4 or later | ||
|---|---|---|---|
| Submitted: | 2005-04-18 03:30 UTC | ||
| From: | jd1 at titleoptions dot com | Assigned: | cschmitz |
| Status: | Closed | Package: | Spreadsheet_Excel_Writer (version 0.4) |
| PHP Version: | 5.16 | OS: | Windows XP |
| Roadmaps: | (Not assigned) | ||
[2005-04-18 03:30 UTC] jd1 at titleoptions dot com
Description:
------------
Somehow, when a sheet is generated with version .4 or later, and if the file is greater than 7MB, MS Outlook 2003 will corrupt the file if it is sent as an attachment. I realize this sounds unlikely, but I have tested it to an extreme and it definatly is happening. The Excel files generated (either as version 97 or 95) become corrupted by outlook only if using version .4 or better of the Spreadsheet_excel_writer to build the sheet. I tried version 3, 4, and 5 of the OLE to go along with this and had same result. Interestingly, if I use version .3 of the Spreadsheet_excel_writer, the issue goes away.
Reproduce code:
---------------
My code is rather complex and would take some work for me to take it out of its context for posting. If you need me to post something here, please contact me. Otherwise, just have a buddy with Outlook 2003 attach one of your sheets and send it. It must be attached to a new message for this to happen (fowarding a sheet does not cause the issue).
Expected result:
----------------
Open one your generated sheets (must be bigger than 7MB) in excel. Opens fine right? Now attach to an Outlook 2003 message and send it. The recipient will get a corrupted file...and it is even corrupt in your sent items. Way to go MS!
If anyone can verify this...please respond. Thanks. JMDill
Comments
[2005-04-18 03:37 UTC] jd1 at titleoptions dot com
More details on the size of the file: First of all, I am meant to say 7KB not 7MB. Secondly, it may also have to do with number of rows. Seems that over 10 rows is about where the problem begins. Small sheets with just a few rows work fine.
[2005-09-08 15:57 UTC] jd1 at titleoptions dot com
Here is the office version:
Microsoft Office Outlook 2003 11.6359.6408 SP1
[2005-11-29 10:24 UTC] krlbak at yahoo dot com
Ran into the same bug with 0.8 beta. After sending a resulting worksheet with Outlook it fails to open, whilst the original opens fine. Outlook version is the exact same as original poster: Microsoft Office Outlook 2003 11.6359.6408 SP1
[2006-02-08 13:40 UTC] czapel at go2 dot pl
I have the same problem. My files are significantly smaller. I have generated some files with size of 40kb and they were also corrupted if I send them using MS Outlook. I use Outlook 2003 (11.8002.6568) SP2. My colleague uses Outlook 2002 10.6515.6735 SP3 and has also this problem.
Regards
cZaPeL
[2006-07-17 21:16 UTC] daniel dot oprean at yahoo dot com
(Daniel Oprean)
I am stuck with the same problem with 0.9 beta.
Seems that files with many different cell formats are affected by this bug. Seems that outlook adds some garbages at xls attachments (don't know why ... this information isn't available anywhere in ms specs) and somehow it affects the data in the file. If you just simply open that file with excel and save it before attaching it, this problem dissappear.
Could it be something about BIFF header max length?
[2007-03-19 19:03 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!
[2007-05-13 20:59 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!
[2007-07-20 18:25 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!
[2007-10-02 18:24 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!
[2007-10-06 13:43 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!
[2007-10-06 15:57 UTC] jd1 at titleoptions dot com
Awesome! Thank you for addressing this.
Personally, I am not so concerned with PHP 4 support.
- Jeremy Dill
[2007-11-06 13:33 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!
[2007-11-06 20:16 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!
[2007-11-15 15:19 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!
[2007-11-15 17:20 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!
[2007-11-15 18:33 UTC] jd1 at titleoptions dot com
You can use the version .3 to gen pretty good sheets. That is what I have been doing for a while (since my original post). However, some features are not available...and the version of the file created is excel 5 i believe, so you will always be asked to save the file no matter if you changed it or not (until it is converted to newer version).
I haven't tried the methods provided by Gareth or Steve yet, but they seem to correspond with what I had assumed to be the problem years ago (the OLE) so I am willing to bet that they would work to get you going on 9+.
I have to say, this is an awesome utility and I am very grateful to its authors.
- Jeremy
[2007-12-29 02: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-08-12 12:44 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-29 06:46 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!