{"action":"created","issue":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/720","labels_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/720/labels{/name}","comments_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/720/comments","events_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/720/events","html_url":"https://github.com/PHPOffice/PHPExcel/issues/720","id":115391029,"number":720,"title":"Strange output quirks in XLS format","user":{"login":"ralplpcr","id":8869912,"avatar_url":"https://avatars.githubusercontent.com/u/8869912?v=3","gravatar_id":"","url":"https://api.github.com/users/ralplpcr","html_url":"https://github.com/ralplpcr","followers_url":"https://api.github.com/users/ralplpcr/followers","following_url":"https://api.github.com/users/ralplpcr/following{/other_user}","gists_url":"https://api.github.com/users/ralplpcr/gists{/gist_id}","starred_url":"https://api.github.com/users/ralplpcr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ralplpcr/subscriptions","organizations_url":"https://api.github.com/users/ralplpcr/orgs","repos_url":"https://api.github.com/users/ralplpcr/repos","events_url":"https://api.github.com/users/ralplpcr/events{/privacy}","received_events_url":"https://api.github.com/users/ralplpcr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-05T22:36:13Z","updated_at":"2015-11-05T23:20:21Z","closed_at":null,"body":"I've been using PHPExcel for a while, and although I love it, there is one quirk that has been driving me crazy - - so I'm hoping someone on here has a suggestion how to work around it?\r\n\r\nI've been using PHPExcel on a server to generate XLS files for upload into our IT system. The problem is that there is something about the PHPExcel output that isn't quite exactly the same. If I try to upload one of the files directly into our IT system, it will fail. However, if I open the file in Excel and then immediately re-save it, it works perfectly?\r\nI've been using PHPExcel for a while, and although I love it, there is one quirk that has been driving me crazy - - so I'm hoping someone on here has a suggestion how to work around it?\r\n\r\nI've been using PHPExcel on a server to generate XLS files for upload into our IT system. The problem is that there is something about the PHPExcel output that isn't quite exactly the same. If I try to upload one of the files directly into our IT system, it will fail. However, if I open the file in Excel and then immediately re-save it, it works perfectly?\r\n\r\nThe file looks identical to the naked eye, and even the file size being reported shows as the same. But if I run an \"FC\" in Windows against the 2 files, it does identify some differences.\r\n\r\nShort of continuing to open/resave files, is there anything that can be done to adjust the output to a more \"true\" Excel file? (and yes, I've already explored automating the open/resave... but I'd rather not have to if at all possible)\r\n\r\nComparing files C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls and C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n€¤ZÐ¯ˆÐ\u0001@\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n€\u0012\\±¯ˆÐ\u0001@\r\n\r\n*****\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n€¤ZÐ¯ˆÐ\u0001\u0003\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n€\u0012\\±¯ˆÐ\u0001\u0003\r\n\r\n*****\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n;óÐ¯ˆÐ\u0001\r\n;óÐ¯ˆÐ\u0001\u0001\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n©ô±¯ˆÐ\u0001\r\n©ô±¯ˆÐ\u0001\u0001\r\n\r\nThe file looks identical to the naked eye, and even the file size being reported shows as the same. But if I run an \"FC\" in Windows against the 2 files, it does identify some differences.\r\n\r\nShort of continuing to open/resave files, is there anything that can be done to adjust the output to a more \"true\" Excel file? (and yes, I've already explored automating the open/resave... but I'd rather not have to if at all possible)\r\n\r\nComparing files C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls and C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n€¤ZÐ¯ˆÐ\u0001@\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n€\u0012\\±¯ˆÐ\u0001@\r\n\r\n*****\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n€¤ZÐ¯ˆÐ\u0001\u0003\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n€\u0012\\±¯ˆÐ\u0001\u0003\r\n\r\n*****\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\test_no_resave.xls\r\n\r\n;óÐ¯ˆÐ\u0001\r\n;óÐ¯ˆÐ\u0001\u0001\r\n\r\n***** C:\\USERS\\Me\\DESKTOP\\WKFILE\\TEST_WITH_RESAVE.XLS\r\n\r\n©ô±¯ˆÐ\u0001\r\n©ô±¯ˆÐ\u0001\u0001\r\n"},"comment":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/comments/154227342","html_url":"https://github.com/PHPOffice/PHPExcel/issues/720#issuecomment-154227342","issue_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/720","id":154227342,"user":{"login":"MarkBaker","id":770298,"avatar_url":"https://avatars.githubusercontent.com/u/770298?v=3","gravatar_id":"","url":"https://api.github.com/users/MarkBaker","html_url":"https://github.com/MarkBaker","followers_url":"https://api.github.com/users/MarkBaker/followers","following_url":"https://api.github.com/users/MarkBaker/following{/other_user}","gists_url":"https://api.github.com/users/MarkBaker/gists{/gist_id}","starred_url":"https://api.github.com/users/MarkBaker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MarkBaker/subscriptions","organizations_url":"https://api.github.com/users/MarkBaker/orgs","repos_url":"https://api.github.com/users/MarkBaker/repos","events_url":"https://api.github.com/users/MarkBaker/events{/privacy}","received_events_url":"https://api.github.com/users/MarkBaker/received_events","type":"User","site_admin":false},"created_at":"2015-11-05T23:20:21Z","updated_at":"2015-11-05T23:20:21Z","body":"So you're basically saying that there's a fault somewhere in the Excel5 Writer..... that doesn't really narrow anything down at all.... I guess I can look at the writer and make a few arbitrary changes in the hope that it fixes things for some external reader application that I have no access to for testing, and hope that it doesn't actually break anything in the process\r\n"}}